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 SP value with dr...
Power Apps
Unanswered

Patch SP value with drop-down menu and refresh

(0) ShareShare
ReportReport
Posted on by 119

Hi,

 

I have a gallery with a drop-down menu and its Items are like this:

Table({ID:10,Label:"10 - Full Compliance"},{ID:8,Label:"8 - Compliant but with Observation"},{ID:4,Label:"4 - Partially Not Compliant -> Minor NC"},{ID:0,Label:"0 - Fully Not Compliant -> Major NC"})

TheSlawekG_0-1674145182151.png

 

The drop-down menu has set the "OnChange" value to:

Patch(AuditsQuestions, ThisItem, {Score: menuScoreA.Selected.ID})

 and this is working as expected. It updates the value of SP with the ID only so I get numbers only.

However, after the change, the drop-down menu remains empty/blank.

 

How can I make the drop-down menu to be refreshed after the update and show what was just updated?

I still want to be able to change the value and ideally would be, if I get the value displayed in the drop-down menu but also the same list of all values that I get from "Items".

 

Can someone help, please?

 

Thank you.

Regards

 

 

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @TheSlawekG 

    Set its Default property to ThisItem.Score or if that doesn't work try

    LookUp(AuditsQuestions,Score=ThisItem.ID,Label)

     

  • TheSlawekG Profile Picture
    119 on at

    Thank you, but unfortunately, both don't work.

    The first solution changes nothing.

    The second gives an error when after .ID I'm typing Label.

     

    Cheers

    Slawek

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

#2
11manish Profile Picture

11manish 193

#3
Valantis Profile Picture

Valantis 138

Last 30 days Overall leaderboard