Answered

Fix drop down value for each row

(0) Share

Report

Posted on by MarwaAlhajri

Hi guys,

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

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
MarwaAlhajri on at

Like (0)

Report
Copy link

Link copied!

I am fetting this error
this is my table

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
MarwaAlhajri on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No