Answered

Nested If Expression is going false all the way through

(0) Share

Report

Posted on by zachm Microsoft Employee

I am trying to assign a string to a number. It is a lookup column in DataVerse, but for what i am trying to do i decided to do a nested if to get the status. I know there is a column associated with the formattedvalue, but I don't know how to get it yet.

If expression:

if(equals(item()?['statusv2'],'1'),'Approved',if(equals(item()?['statusv2'],'2'),'Denied',if(equals(item()?['statusv2'],'3'),'Not Reviewed',if(equals(item()?['statusv2'],'4'),'Trip Approved;Business class airfare denied',if(equals(item()?['statusv2'],'5'),'Pending CVP Approval','n/a')))))

Data structure:

Screenshot 2022-10-19 101924.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Redders 546 on at

Like (0)

Report
Copy link

Link copied!
Try this
if(equals(item()?['statusv2'],1),'Approved',if(equals(item()?['statusv2'],2),'Denied',if(equals(item()?['statusv2'],3),'Not Reviewed',if(equals(item()?['statusv2'],4),'Trip Approved;Business class airfare denied',if(equals(item()?['statusv2'],5),'Pending CVP Approval','n/a')))))
━━━━━━━━━━━━━━━━━━━━━━━━━

If I have answered your question, please mark your post as Solved.

Solved 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. Thank you!

Was this reply helpful? Yes No
zachm Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I was able to get the formattedvalue to work, but i'd like to understand why my IF didn't work.

This is the format i used as an expression.
item()?['cr74d_statusv2@OData.Community.Display.V1.FormattedValue']

Was this reply helpful? Yes No
zachm Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I tried taking out the single quotes, but it still isn't working. did you change anything else?

Was this reply helpful? Yes No
Redders 546 on at

Like (0)

Report
Copy link

Link copied!

No, that's all I did.
Sorry, I'm not sure then

Was this reply helpful? Yes No
Verified answer

zachm Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I just added the table identifier? in front and the logic worked. cr74d. Thanks
if(equals(item()?['cr74d_statusv2'],1),'Approved', if(equals(item()?['cr74d_statusv2'],2),'Denied', if(equals(item()?['cr74d_statusv2'],3),'Not Reviewed', if(equals(item()?['cr74d_statusv2'],4),'Trip Approved;Business class airfare denied', if(equals(item()?['cr74d_statusv2'],5),'Pending CVP Approval','n/a')))))

Was this reply helpful? Yes No