Dynamically add item to lookup list

[golfnutt82]

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?

[golfnutt82]

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?

[v-bofeng-msft · Accepted solution]

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

[golfnutt82]

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