Trigger Condition or JSON If Statement? Instant Flow should run but dependent on item chosen in choice column

(0) Share

Report

Posted on by AD-22072132-0

I have an instant flow programmed in a column as a button (with JSON) that when ran it will populate a Word Template.

I have choice column named Template with 11 different choices that should trigger to 11 different Word Templates.

Depending on the Template chosen, I'd like the button run the correct flow.

Choose Template1, then click button, run flow Template1.

Choose Template2, then click button, run flow Template2, etc.

Is this possible?

Within the Format Column of the instant flow button, I figured I need a nested if statement in the JSON at "actionParams" but just can't get it to work. Maybe I'm going at it all wrong?

I tried to just test two different flow ID's in the if statement as a test but get the error:

Unexpected token '=', "=if([$Temp"... is not valid JSON

"actionParams": "=if([$Template] == 'Template1’, {\"id\": \"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx001\"}, {\"id\": \" xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx002\"}"

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
Try the code below:
"=if([$Template] == 'Template1', '{\"id\": \"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx001\"}', '{\"id\": \" xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx002\"}')"

Three things different to yours:
You had a formatted single quote after Template1. Maybe you copied it from somewhere else.
You didn't include the outputs in single quotes.
You were missing a ) to close off the if statement.

Was this reply helpful? Yes No
AD-22072132-0 on at

Like (0)

Report
Copy link

Link copied!

Well, it is now valid JSON, but it is always false, triggering the second id.
Column is Template, choice is Template1, why isn't it seeing as true?

"actionParams": "=if([$Template] == 'Template1', '{\"id\": \"xxxtruexxxx\"}','{\"id\": \"xxxfalsexxx\"}')"

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
When I copy your code directly into my list it works successfully.

Three things to check:
Is Template the internal name of the column, or was it renamed? Your JSON refers to the internal name, not the display name.
Are you sure you don't have a space or something after your Template1 value?
Can you try one of the other choices to see if one of them work?

Was this reply helpful? Yes No
AD-22072132-0 on at

Like (0)

Report
Copy link

Link copied!

First thing you suggested was the issue. It had been renamed just for this testing. I modified the code to that 'internal name' and it now works.

Now to create the 11 deep if statement!

Thanks.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

Great it's now working 🙂

Why do you need a 11 deep if statement? I thought you were going to have individual flows for each of the Templates?

If you do need to go that deep, then I'd suggest looking at using a Switch action instead. But still not sure why you would need a conditional statement at all.

Was this reply helpful? Yes No
AD-22072132-0 on at

Like (0)

Report
Copy link

Link copied!

Heck, I do think it is a bit psychotic to create an 11 deep nested if statement.
My logic was to have that if statement run until it found the true scenario, then it would run that flow.

I'm figuring to have 11 flows since there are 11 unique Word template documents that could be populated depending on the 11 choices in the Template column.

I suppose I could do one flow, with a Switch action on the Template Value and 11 Cases. A bit less insane.

Was this reply helpful? Yes No