Patch not accepting Dropdown Value

(0) Share

Report

Posted on by Skybluekid

262

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (3)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Thank you

Was this reply helpful? Yes No