Updated specific locations to be searchable, take a look at Las Vegas as an example.

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

6
Power Automate Multiple nested if statement
Post Body

Hi all, I'm having a lot of problem with a multiple nested if statement expression I'm trying to implement into my flow. Essentially I'm creating a reminder email of Active Requests for an approval flow I created and the email will send a list of the requests with specific key columns. The if statement is an extra column I'm creating which will detail the "Action Required" depending on the submission status of the item.

I've tried multiple ways creating the expression, both by putting the "Action Required" text directly into the if statement "true" field, to putting each text into its own compose and drawing from that. Ive also tried encapsulating each if statement into a concat expression but this has not helped either, refer statements below and a screenshot for the Select action in the link.

Could anyone please review if I've somewhere made a mistake in the logic to cause the "The expression is invalid." error in receiving? Thanks.

concat(if(equals(item()?['SubmissionStatus/Value'], '1 - Awaiting Review'), '1', ''), if(equals(item()?['SubmissionStatus/Value'], '2 - Awaiting Signed Forms'), '2', ''), if(equals(item()?['SubmissionStatus/Value'], '4 - Approved, IT Ticket Required'), '3', ''), if(equals(item()?['SubmissionStatus/Value'], '5 - Ticket Raised'), '4', ''), if(equals(item()?['SubmissionStatus/Value'], '6 - Login Credentials Sent'), '5', ''), if(equals(item()?['SubmissionStatus/Value'], '7 - Portal Training Required'), '6', ''))

if(equals(item()?['SubmissionStatus/Value'], '1 - Awaiting Review'), '1Test', if(equals(item()?['SubmissionStatus/Value'], '2 - Awaiting RCTI/T&C's Forms'), '2Test', if(equals(item()?['SubmissionStatus/Value'], '4 - Approved, SNOW Ticket Required'), '3Test', if(equals(item()?['SubmissionStatus/Value'], '5 - Ticket Raised in SNOW'), '4Test', if(equals(item()?['SubmissionStatus/Value'], '6 - Portal Login Credentials Sent'), '5Test', if(equals(item()?['SubmissionStatus/Value'], '7 - Vendor Portal Training Required'), '6Test', 'Complete'))))))

Author
Account Strength
70%
Account Age
3 years
Verified Email
Yes
Verified Flair
No
Total Karma
2,716
Link Karma
372
Comment Karma
2,267
Profile updated: 20 hours ago
Posts updated: 1 year ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
1 year ago