Adding new items to associated lookup, via edit form in one submission.

(0) Share

Report

Posted on by Modulas

146

What would you do if you wanted to update your lookup table from your form submission?

i.e as you're filling out your form, you have to make a new entry into the lookup as it doesn't exist and you want that to save with the item in the form, but also pipe back up as a future option in the look up table?

Can you set the combo box to have a manual entry option and pipe it in that way?

Again, it has to effectively update two tables.

All I can think of is doing a patch or form into the look table prior to filling out the larger form.

Thankyou

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

365-Assist 2,324 Moderator on at

Like (0)

Report

1 - Save the option to the Form. This video explains well SharePoint HTTP Action add Choice Value with Power Automate - YouTube . Don't worry about the SharePoint stuff. Replace it with step 2 below.

2 - You will need to use Power Automate to add the choices to the DV table. Here is a video I found that may help Automatically Updating A Dataverse Choice list (Option Set) - YouTube
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @silaman ,

Your thought is correct. You will need to generate item in LookUp table first. But to achieve this we have an easy way:

1. Add a button beside the Combobox within the Card. OnSelect set to update the LookUp table:

Patch(LookUpTable, Defaults(LookUpTable), {PrimaryNameColumn: Combobox.SearchText})

2. DisplayMode of the Submit button:

If( IsBlank(Combobox.Selected), DisplayMode.Disabled, DisplayMode.Edit, )

So only when there is an item selected in the combo box, users are able to submit the form.

Best regards,

Was this reply helpful? Yes No
Modulas 146 on at

Like (0)

Report

Thanks for this, there aren't many alternatives but this seems the simplest.

Was this reply helpful? Yes No
Modulas 146 on at

Like (0)

Report

Thanks for you suggestion, however there is ready a lot of automation going on which causes delays sometimes, and I don't want members having to wait for automation going on in the background before they can see a result as they're filling out a table or trying to make multiple entries.

Was this reply helpful? Yes No