Restrict 'Yes/No' field to one YES

[Data_Enthusiast]

Hi Power Apps Community,

I am trying to build an app where in a Gallery of items I have a field - let's call this FieldA, which is a 'Yes/No' field. Out of all the items in the Gallery, if FieldA is 'Yes' for any one item, then you may not have 'Yes' for any other item in the Gallery.

I would really appreciate any assistance.

Thank you in advance.

[eka24]

Can you show a screenshot?

Meanwhile try:

If(ThisItem.Column="Yes","Yes","No")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Data_Enthusiast]

Hi @eka24 

Sure. The screenshot below would show a list of all the items in the Gallery. Out of all the items in the Gallery, a user may only select one of the items to be identified as a 'Main Item'. If one is identified, all other items should be false.

The screenshot below shows the control used to select whether the item is a 'Main Item' or not.

Hope this helps. 

[eka24]

It seems the Toggle used to select main item is not inside the Gallery. 

If(Toggle1.Value,"true","false")

If that doesn't work, click the items inside the Gallery to display the ThisItem

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Data_Enthusiast]

Hi @eka24 

Yes, there is a separate Details Page for editing the fields.

With regards to your code, which property of the Toggle would I add the code to?

[eka24]

Please in design mode, click inside the Gallery to display the formula in the Label and take a screenshot

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Data_Enthusiast]

Hi @eka24 

This is the formula used for the Label.