Answered

If Statement in Expression not Returning Expected Results

(0) Share

Report

Posted on by CW

1,042

Hello. I've tried for hours to get a text field in an html table to show "Yes', when it's value is yes in the SharePoint list and '' (no value) when the value is "No'.

I've initialized a string variable to:

if(equals(item()?['SetListtxt'], 'Yes'), 'Yes', '')

As a test I added the actual field so I can ensure it's working.

It should view in the HTML table as: [dynamic field value]/[variable] so: Yes/Yes, No/ , etc. but all I'me getting is Yes/ , No/ menaing the variable expression is not working and I dont underdtaand why. I thought it was supposewd to bew as simple as Excel if statements but this is furthest from.

HELP

I've included pertinent images for reference.

Thanks

Email.png

Flow.png

SharepointList.png

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

Re: If Statement in Expression not Returning Expected Results

Hi @CW ,

Your expression should be used in action 'Create html table' instead of the 'init variable' action because item() function should be used in a loop.

Best Regards,

Wearsky

Was this reply helpful? Yes No
CW 1,042 on at

Like (0)

Report

Re: If Statement in Expression not Returning Expected Results

Tx for your reply, very much appreciated.
I tried using the same expression in the create table but it kept saying the expression was wrong (????).
Why does MSFT have to make EVERYTHING so difficult. If it knows it's wrong, and intellisense has enough to understand whether it's wrong or right then it should provide the proper or corrected expression or at least example.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: If Statement in Expression not Returning Expected Results

Hi @CW ,

Could you share some screenshots?

Best Regards,

Wearsky

Was this reply helpful? Yes No
CW 1,042 on at

Like (1)

Report

Re: If Statement in Expression not Returning Expected Results

Actually what I did was create a new line (header/data) and used this expression:

If(equals(item()?['SetListtxt'], 'Yes'), 'Yes', ' ')

which worked perfect.

Thanks for the suggestion to put it in the Create Table action.
I think initially my expression was incorrect. Maybe a ')' in the wrong spot but all working good now.
Thanks

Was this reply helpful? Yes No