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 / Fix drop down value fo...
Power Apps
Answered

Fix drop down value for each row

(0) ShareShare
ReportReport
Posted on by

Hi guys,

 

My issue is that I have created a galley that contains multiple rows. For each row, the user will enter a value 

MarwaAlhajri_1-1719210221698.png

 

What I want is to fix the currency drop-down value, for example, if they select OMR the second row should be only OMR they cannot select a different currency is there a way to do it 

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @MarwaAlhajri ï¼Œ

     

    You could set the combobox's OnChange property to:

    Set(TempValue,Self.Selected)

    And set the combo box's items property to:

    Filter(DataSource,ColumnName=TempValue.ColumnName || IsBlank(TempValue))

    When you submit the info , you also need to reset the variable TempValue

    Set(TempValue,Blank())

     

    Best Regards,

    Bof

  • MarwaAlhajri Profile Picture
    on at

    I am fetting this error 

    MarwaAlhajri_0-1719211778734.png

    this is my table 

    MarwaAlhajri_1-1719211808000.png

     

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @MarwaAlhajri ,

     

    Please clear the control's items property and input:

    Filter(
     Distinct('Your SP List',Title),
     Value=TempValue.Value || IsBlank(TempValue.Value)
    )

     

    Best Regards,

    Bof

  • MarwaAlhajri Profile Picture
    on at

    This solved the issue thanks, but what happens now is if an employee selects one of the currencies and wants to change it, for he chooses the wrong currency it will only show the currency he selected even if I clear the column 

    MarwaAlhajri_0-1719386478479.png

     

    can it be interactive like if I changed the first line the second will change accordantly 

    Thanks for the help

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 88

#2
WarrenBelz Profile Picture

WarrenBelz 85 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 45

Last 30 days Overall leaderboard