Answered

Reset Dropdown in galleryy

(0) Share

Report

Posted on by Gelos

457

have 3 drop down in gallery. there drop down has same value name1 and name2 and name3. I should not allow user select same value these dropdown. so i user Reset property but problem is I have 5 item in gallery. if I reset 1 item 2 nd dropdown at the time all 5 items second drop down also reset how to avoid this. I want to achieve only reset 1st item 2 nd dropdown. please help me.

@Mike8 @WarrenBelz @RandyHayes @Pstork1

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Gelos ,

I did a simple demo for you.

1\ This is my gallery 'Gallery1' .

2\ Insert a dropdown control 'Dropdown1' into the gallery .

Set the dropdown control 's AllowEmptySelection property to:

true

Set the dropdown control 's onchange property to:

ClearCollect(Col,ForAll(ShowColumns(Gallery1.AllItems,"Dropdown1"),Dropdown1.Selected.Value));If(CountRows(Filter(Col,Value=Dropdown1.Selected.Value,!IsBlank(Value)))>1,Reset(Dropdown1))

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Gelos 457 on at

Like (0)

Report
Copy link

Link copied!

Thankyou for your replay. but the three dropdowns must be all row rows.
1 st row has three dropdown,
2 nd row has three dorpsown,....................................n row
like that

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Gelos ,

I don't quite understand your needs...

Could you explain it?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Gelos 457 on at

Like (0)

Report
Copy link

Link copied!

In gallery I have five rows I set each row has three dorpdown.
1 dd1, dd2,dd3
2 dd1,dd2,dd3
3 dd1,dd2,dd3
like that. If user choose name1 in dd1 the user should not choose name1 in dd2 and dd3 in first row the same condition applied remining rows . I show the the names from cds table.
thankyou

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Gelos ,

I did a simple demo for you.

1\ Add a dropdown control 'Dropdown1' and set its Items property to:

'Test 101S'.Name

2\ Add a dropdown control 'Dropdown2' and set its Items property to:

Filter('Test 101S'.Name,Dropdown1.Selected.Name <>Name)

3\ Add a dropdown control 'Dropdown3' and set its Items property to:

Filter('Test 101S'.Name,Dropdown1.Selected.Name <>Name&&Dropdown2.Selected.Name<>Name)

4\ The result is as follows:

This solution can only select values from the dropdown control from left to right.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No