Answered

Creating if statement expressions

(0) Share

Report

Posted on by Community Power Pla...

I would like to make an expression but am unsure how to

I would like it to be an if statement of sorts. I'm pulling data from powerapps, including an item called "NA smoking another"

This will produce either a "true" or "false" result.

I'm populating a word docx with checkboxes, and one of the methods was to make a variable and insert it (i have confirmed this works).

How would I write an expression where in which if the "NA smoking another" is true, then initialise variable will be inserted into the word output (eg in Dose 12 row), if not then initialise variable 2 will be inserted into the word output (eg in dose 12 row)

Any advice on building this would be greatly appreciated

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey Mate,

You can use the If expression to validate the data. You can also it pass the correct data in your Word template

if Returns a specific value if the expression results in true or false. This expression returns "yes":
if(equals(1, 1), 'yes', 'no')

You can find more details in the video - https://www.youtube.com/watch?v=1T1sBPpVOj0

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey Mate, Yeah i want the if statement to pass on data
My query was moreso on how would i write the expression i was talking about:
How would I write an expression where in which if the "NA smoking another" is true, then initialise variable will be inserted into the word output (eg in Dose 12 row), if not then initialise variable 2 will be inserted into the word output (eg in dose 12 row)
I was thinking something along the lines of If(NA Smoking another="true", variable 1, variable 2)
However, i dont know how to write it viably such that powerautomate can process that as it keeps prompting saying "the expression is invalid"

Was this reply helpful? Yes No
Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

Hey @Anonymous

Something like this?

if(equals(triggerBody()['boolean'],true),variables('Variable1'),variables('Variable2'))

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No