Answered

Exporting Boolean Values to CSV

(0) Share

Report

Posted on by Saul85

Hello!

I did a flow which exports to a CSV part of my SP list. When I open the created CSV the boolean values appears as a TRUE or FALSE instead of YES or NOT as shown in my SharePoint list.

Any help to correct the wording from TRUE/FALSE to YES/NO will be really appreciated.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Saul85,

You could use the replace() function to convert the true to yes and false to no, for example:

replace(replace(output('Compose'),'true','yes'),'false','no')

Best Regards,
Community Support Team _ Lin Tu
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
Saul85 35 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-litu-msft

Thanks for your answer, but still not working.
The system can only replace strings, so the boolean is not supported apparently. Any suggestion on how to fix the problem?

Regards

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Saul85,

Boolean could also use the replace() function, you could use string() function convert whole object to string, then use json() function convert it back.

json(replace(replace(string(output('Compose')),'true','yes'),'false','no'))

Could you please share an instance?

Best Regards,
Community Support Team _ Lin Tu
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
Saul85 35 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-litu-msft

Find below a screenshot. I just need to change the Boolean in the CSV, is already well displayed in the SP list.

Thanks.

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Saul85,

OK, do like this:

replace(replace(string(item()?['Read']),'True','YES'),'False','NO')

Best Regards,
Community Support Team _ Lin Tu
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
Saul85 35 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-litu-msft,

Thanks a lot for your help, now is working.

Regards.

Was this reply helpful? Yes No