Restrict 'Yes/No' field to one YES

(0) Share

Report

Posted on by Data_Enthusiast

383

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24
This is the formula used for the Label.

Was this reply helpful? Yes No