Unanswered

Patch from dropdown list but select description not ID

(0) Share

Report

Posted on by arar2023

I'm fairly new to Power Apps. I pull the Description from a SharePoint list called "ListRequestBusiness" that looks like this:

and pull the Business Description in Items using this: ForAll(Distinct(CollectListRequestBusiness,Description), {Result: ThisRecord.Value})

The Sharepoint List ListRequestBusiness has three columns:

I want to update my SharePoint list "ListRequest" to pick up the "Description_EN" but while using the OnSubmit button with SubmitForm(Form1); it pulls in the IDBusiness. Can I also use the Patch function to pull in the Business "Description_EN" into the sharepoint list?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

vivekravi 241 on at

Like (0)

Report

which column/SP list are you patching?

Was this reply helpful? Yes No
M_Ali_SZ365 1,110 on at

Like (0)

Report
Hi @arar2023
se the submit button to save your form as usual.
Then add a Patch command right after your SubmitForm() in the button's OnSelect property.
It'll look something like this:

SubmitForm(Form1); // This submits your form Patch( ListRequest, Form1.LastSubmit, {Description_EN: Dropdown1.Selected.Description_EN} ); // This updates the English description

Remember to swap in the right names for your dropdown control and list columns. This way, you submit your form, and then immediately update the English description to the one you picked from your dropdown.
Please accept this solution if it resolves the issue. ✅
Best regards,
Muhammad Ali

Was this reply helpful? Yes No