Power Platform Community Forum Thread Details

I am trying to wrap my head around how things are done on Power Apps. Struggling with with an if statement....basically I am working on an app that will be used to reserve seats for various activities. I have a button on my gallery, but I want it to display different text, depending on multiple conditions. In my SharePoint list, I have...

1- multi select person column called Participants

2- number column called 'Available Spots'

3- multi select person column called Waitlist

Here is the logic i am trying to get....

if the user is not in the Participants column and Available spots > 0....then the button should say "Click to reserve a spot"

if the user is already in the Participants column , then the button should say something like "You are already on the list"

if the user is not in the Participants column and Available spots <= 0..."No more spots, You can get on waitlist"

if the user is in the Waitlist column, then the text should be "Already on the waitlist"

So far, i have only been able to come up with

If(
  IsBlank(
   'Activities', User().Email in ThisItem.Participants.Email
  ),
  "Click to reserve",
  "You are already on the list"
);

Challenge getting all the other conditions in.

Categories:

Building Power Apps

Community site session details

How do i include multiple conditions in an IF statement?

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates