Reset Dropdown in galleryy

Like (0) Share

Report

Posted on 2 Aug 2021 11:46:43 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

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

v-xiaochen-msft on 06 Aug 2021 at 09:42:44

Like (0)

Report
Re: Reset Dropdown in galleryy

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
Gelos 457 on 06 Aug 2021 at 08:14:00

Like (0)

Report

Re: Reset Dropdown in galleryy

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
v-xiaochen-msft on 06 Aug 2021 at 07:54:10

Like (0)

Report

Re: Reset Dropdown in galleryy

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 06 Aug 2021 at 07:50:12

Like (0)

Report

Re: Reset Dropdown in galleryy

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
Verified answer

v-xiaochen-msft on 03 Aug 2021 at 02:36:54

Like (1)

Report
Re: Reset Dropdown in galleryy

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