Unanswered

Yes/No column not updating through excel update

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

i am currently running a flow where i am fetching the data from excel and uploading it in Sharepoint list. Everything works perfect however, my yes/no column is behaving differently.

I tried uploading data for 1 record through the flow and the yes/no column still shows No value even though the file contained yes value.
i have tried updating the column with Yes and True. Both did not work, and it is happening for almost all yes/no column.
FYI the default value is set to No for all the Yes/No Columns.

Hope you could help me out in this.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Hi!

TRy to use

true

or

false

Please inject them as expressions

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

So you will probably need to translate Yes/No into true/false by means of an if() based expression. Assuming you store Excel column content in avariable called 'myInputExcelYesNoColumn', and possible values were Yes / No

if(equals(variables('myInputExcelYesNoColumn'],'Yes'),true,false)

Hope this helps

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report

Hi @Anonymous ,

As @efialttes said, if you want to update a "Yes/No" column in a sharepoint list, you could update the Yes/No type column with true or false, you could take a try to update the column with custom value from the if() expression provided by @efialttes .

And you could save the column value from the excel row in a Compose field, then you could use the if expression to check if the value is equal to yes, if the value is equal to Yes, update the Yes/No column in the list item with true, or if the value is No, update the Yes/No column in the list item with false.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No