Get value of Choices column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi I would like to Update item of share point by Flow.

The choice column value should be opposite.

I wrote the expression as below, but it seems not correct.

Column Type is Yes/No, the other is Choices.

If(body('Apply_to_each')?['FilesOtherthanPPT']?['Value'],'Yes'),'No','Yes')

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

It's difficult to give you an answer without a screenshot.

To evaluate the IF condition you need an Equal expression to check the value whether its Yes/No so that it will return the boolean to check against the IF condition.

I think this is what you need

if(equals(body('Apply_to_each')?['FilesOtherthanPPT']['value'],'Yes'),'Value is Yes','Value is No')

Change the Value is Yes and Value is No accordingly.

Thanks

Was this reply helpful? Yes No
MattWeston365 1,701 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

The first part of the IF expression must always equate to either TRUE or FALSE. You are just missing a comparison expression, so here you could just add equals:

If(equals(body('Apply_to_each')?['FilesOtherthanPPT']?['Value'],'Yes'),'No','Yes')

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

Like (0)

Report
Copy link

Link copied!

Hi Thank you for you reply. I still could get the right value.
I don't know if it is because Column Type is Yes/No, the other is Choices.

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

Like (0)

Report
Copy link

Link copied!

Hi Thank you for you reply. I still could get the right value. I don't know if it is because Column Type is Yes/No, the other is Choices.

Was this reply helpful? Yes No
MattWeston365 1,701 on at

Like (0)

Report
Copy link

Link copied!

Ah ok, if it's a Yes/No field then you need to test for whether something is true or false, rather than yes or no.

So rather than having 'Yes', change it to true.

If you are dealing with a choice field, then you will need to compare for a string, therefore the format that you're using at the moment is correct.

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

Like (0)

Report
Copy link

Link copied!

Hi I tried this :if(equals(body('Get_items_Review')?['FilesOtherthanPPT']?['Value'], 'True'), 'いいえ','はい')
'いいえ','はい' is the choices. But it is still not working.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Add a compose and copy your expression

body('Get_items_Review')?['FilesOtherthanPPT']?['Value']

This way you can easily evaluate what value is returning using the run history. Then change the value accordingly.

Thanks

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Also I am not sure you need to check true in quotes. It's worth a try without having quotes. Before you do this make sure debug the expression via compose which I mentioned earlier.

Thanks

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

Like (0)

Report
Copy link

Link copied!

Hi I tried the true, bool(1), bool(Yes),bool(true), but not working.

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

Like (0)

Report
Copy link

Link copied!

Hi I added the compose action and use if(equals(outputs('Compose'), 'Yes'), 'いいえ','はい'), but I still could not get the right result.

Was this reply helpful? Yes No