web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch with Drop Down O...
Power Apps
Answered

Patch with Drop Down OnChange

(0) ShareShare
ReportReport
Posted on by 6

I have a Gallery that is showing records from Table2:

 

Items = SortByColumns(Filter(Table2,'Quality order' = QualityOrderListGallery.Selected.'Quality order'),"Sequence",Ascending)

 

The Result column in this Gallery will show either a Drop Down, or a Text Input.

 

TestsGallery.jpg

 

The Text Input shows the value in the Result field of Table2. If the user changes the value, the updated value is written to the relevant record in Table2:

 

Default = ThisItem.Result

OnChange = Patch(Table2,ThisItem,{Result:ResultFreeText.Text})

 

I would like the Drop Down to behave the same way, but I am getting an error on the OnChange property:

 

Items = Filter(Table3,Test in ThisItem.Test)
Value = Result
Default = ThisItem.Result
OnChange = Patch(Table2,ThisItem,{Result:ResultDropdown.Selected})

 

The error on the OnChange property reads:

This type of argument 'Result' does not match the expected type 'Text'. Found type 'Record'.

 

How can I get the value which the user selects in the Drop down to be written back to Table2?

 

 

Categories:
I have the same question (0)
  • pontusofsweden Profile Picture
    255 on at

    Hi!

     

    Try to add .Value in the OnChange property. Like:

    OnChange = Patch(Table2,ThisItem,{Result:ResultDropdown.Selected.Value})

     

    BR

    Pontus

  • Guy Terry Profile Picture
    6 on at

    That gives a slightly different error!

     

    This type of argument 'Result' does not match the expected type 'Text'. Found type 'Error'.

  • Verified answer
    pontusofsweden Profile Picture
    255 on at

    Hmm ok. Try SelectedText instead then. Then you should get the Text value from the dropdown.

     

    OnChange = Patch(Table2,ThisItem,{Result:ResultDropdown.SelectedText.Value})

    BR

    Pontus

  • mdevaney Profile Picture
    29,991 Moderator on at

    @GuyTerry 

    When a dropdown is referenced in this way it returns a record (i.e. a row of data)

    {Result:ResultDropdown.Selected}

     

    I believe Result is a text column so you will have the reference the dropdown in a way that returns text

    {Result:ResultDropdown.SelectedText}

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Guy Terry Profile Picture
    6 on at

    Thank you both. SelectedText.Value gives me the behaviour I wanted 😀

  • gomezjr Profile Picture
    22 on at

    @pontusofsweden @GuyTerry @mdevaney 

    What is the selected value needs to be compared/matched to an items multiple choice column?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard