Hi
I have a SP list with a column called "Outcome", which is a Text Value. In my app I have a Dropdown called Verdict and I use this Patch function to update the list:
Patch(tbl,LookUp(tbl,Title=Record),{User: varUser, Outcome:Verdict.Selected, Date:Today(), 'Notes': Notes})
The values in the Dropdown are Approved and Rejected. If I hard code "Approved" in the Patch function, there is no issue. But if I change it to the above, it will error.
Any ideas would be helpful.
Thank you
Hi , @Skybluekid
You can try to use this code :
Patch(tbl,LookUp(tbl,Title=Record),{User: varUser, Outcome:Verdict.Selected.Value, Date:Today(), 'Notes': Notes})
The Verdict.Selected return a record. You need to use the Verdict.Selected.fieldName to get the selected item's value from your dropdown control.
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang