Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Patch not accepting Dropdown Value

(0) ShareShare
ReportReport
Posted on by 252

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.

 

 

Categories:
  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Patch not accepting Dropdown Value

    Thank you

  • Verified answer
    Re: Patch not accepting Dropdown Value

    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.

    vyueyunmsft_0-1706785159365.png

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard