Share
ReportI have a list with a column [Approval%] which calculates a variation +/- 20% of other columns and the output is Yes/No formatted. The Approval% column produces the correct result when the values are changed (i.e. Yes/No), so I know the formula in the list is working.
The flow I set up has a 'get item' action which pulls the list values and a condition:
@equals(body('Get_item')?['Approval_x0020__x0025_'], 'yes') which evaluates if the variation is outside the range. If Approval% value is = 'yes' it should kick off an approval. If = no, it should send an email.
Not matter what expression I put the condition ALWAYS produces a 'false' output and sends the email, not the approval.
I've tried [Yes] in single quotes, double quotes, bool(true), bool(1), yes, true, 1, and every varation thereof. No matter how I format it the expression always produces a false.
Am I missing an action step to retrieve the column values? Does the fact that the column is calcuated effect it? Is there a different trigger I should use? I'm losing my mind....
All responses (
Answers (
497
