Dynamically add item to lookup list

(0) Share

Report

Posted on by golfnutt82

1,360

From a SharePointIntegration form pointing at a SharePoint list my form contains lookups.

When the user opens the form and clicks any of the drop downs, the dropdown may not have the selection they are looking for.
Is there a way to add a lookup value dynamically without having to leave the form and manually add the item to the lookup list?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

golfnutt82 1,360 on at

Like (0)

Report

Ok, I was able to find a way to dynamically add a new lookup list item when the lookup on the form doesn't have the value I am looking for.
I created a new screen that is connected to the datatype (GageType) where the lookup values are.
In the GageType lookup list of values I added a value called "New Entry".
When in the main form, where I am adding a new Item, I click the Gage Type dropdown and chose "New Entry".

Using the OnChange event for the DataCardValue4 control, I set the navigation to open the new "GageTypeNewForm1" form when "Add New" is selected.

The Add New Gage Type form opens where I can now add the new gage, save and then open the GageTrackingToolForm.
The issue I now have is the current Gage Type lookup doesn't get updated with the new entry.
Am I missing something?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report

Hi @golfnutt82 ,

Please refresh the data source after you add a new item into tblGageType. For example:

Patch(tblGateType,Defaults(tblGateType),{XXXXXX};

Refresh(tblGateType);

Refresh(GageTracking);

Navigate(GageXXXXXX)

Best Regards,

Bof

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

Hello and thank you for your reply and the added refresh did the trick.

Was this reply helpful? Yes No