If expression only showing false - Email Notification expression

[Lizzlenizzle]

Hi all, hoping to get some help with an issue.

I have a flow that is triggered by a new response to a Microsoft Quiz for it to create a list item in SharePoint, then it collects that item, then sends an email to the individual who completed the quiz and their manager with their score (using calculated columns in SharePoint) and their answers to each question.

We are wanting to indicate if the answer they have selected is correct or incorrect. On the SharePoint list I have created some calculated columns for each corresponding question (so question 1 has an answer column called 'A1') and these all contain a value set to be 1 if the answer is correct, and 0 if the answer is incorrect, providing them with points for each question. These columns are hidden on the SharePoint list.

I wanted to set an expression in the email response advising if the answer is correct or incorrect, using the value from the calculated column. What I have so far is:

if(equals(outputs('Get_item')?['A1'], 1), 'Correct', 'Incorrect')

Unfortunately this only displays the incorrect result in the email even though it was correct and the number 1 displayed in the A1 column. I know for sure that these columns are still calculating while hidden because the score is calculated from those fields. I have also tried the same expression trying IF(AND( and the flow failed, and I tried using integer as well. 

Can anyone assist?
Please see below for screenshots.

This is the way I'm inserting the expression.

This is the flow overall.

The final email with the incorrect results.

[elliottliu]

Hi @Lizzlenizzle,

This seems to be because the field coming from your "outputs('Get_item')?['A1']" is a string, where it needs to be an integer value. Try wrapping it inside an "int()" expression - hopefully this should do the trick:

if(equals(int(outputs('Get_item')?['A1']), 1), 'Correct', 'Incorrect')

Best of luck!

[Lizzlenizzle]

Thanks for your response! 
I’ve left work now so I’ll give it a go tomorrow but I did try using int in that spot but either it did the same thing or the flow failed (I forgot which since I tried a few different ones). 

[elliottliu]

No worries, give it a go again and let me know the outcome (with a screenshot if possible)!

[Lizzlenizzle]

@elliottliu I gave it a go using 

if(equals(int(outputs('Get_item')?['A1']),1),'Correct','Incorrect')

I got the following error:

Unable to process template language expressions in action 'Send_an_email_notification_(V3)' inputs at line '1' and column '21984': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

[v-xiaochen-msft]

Hi @Lizzlenizzle ,

You only need to use a compose action to troubleshoot.

Firstly ,use this expression on 'compose' action and run this flow to check outputs of your compose action.

outputs('Get_item')?['A1']

Could you provide the output of this expression?

Best Regards,

Wearsky

[Lizzlenizzle]

@v-xiaochen-msft How do I provide the output - sorry, I'm quite new to using compose. I popped in a compose action and ran the flow, but when I selected "Download outputs" it just goes to a blank web-page.

[v-xiaochen-msft]

Hi @Lizzlenizzle ,

This means that the output of your expression (outputs('Get_item')?['A1']) is null.

In fact, sharepoint calculated column have problems/bugs in flow or canvas sometimes.

If you use powerapps/powerautomate, calculated column is not a good choice.

If the column has a value in Sharepoint but it does't have a value in flow , it might be a bug I think.

Best Regards,

Wearsky

[Lizzlenizzle]

@v-xiaochen-msft Just strange because the expression above that references a different conditional column I have set up in the same SharePoint list called Score - but I'm using this expression for that: 

formatNumber(int(outputs('Get_item')?['body/Score']), '0,0')

If I was to convert my conditional columns to say "Correct" or "Incorrect", do you think I'd have better luck being able to display that text instead of using an IF statement? I've had a brief look around and I'm not sure what formula I'd need for just displaying the text value from a column.