Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

If statment with labels


I am trying to use three if statements to decide which label to use.

I am reeding out of one excel column, in this excel column there are three key words NO, OK, and Ongoing. I want to use the if statement to differ between the three key words. For example I want No to be Red, Ongoing to be yellow and green to be ok.


RED: if(contains(‘items(‘List’)?[‘Class Status’]’, ’NO’), ‘Yes’, ‘No’)


Yellow: if(contains(‘items(‘List’)?[‘Class Status’]’, ’Ongoing’), ‘Yes’, ‘No’)


Green: if(contains(‘items(‘List’)?[‘Class Status’]’, ’OK’), ‘Yes’, ‘No’)


The column is named ‘Class Status’ and the Apply to each controller is named List.

I am hoping to be using this block and write the is statements in hear:)



Can one of you help me fix the statements or help me find a better way to do it?




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (3,431)