True and False expression on powerautomate does not sync with sharepoint list

Question

Hi everyone,

I have created a sharepoint list and configure the column to be Yes or No. It will indicate a tick for Yes while for No it will be left blank. When i configure my automation for the select action i have use expression if(equals(item()?['field_3'],true),'Yes','No') to generate the Yes or No. It ran successfully however instead of Yes for true cases (tick), it generated No instead in the following create HTML table. Attach is my flow and portion of the detail for visibility.

Any help is appreciated.

Flow overview

HTML Table

Sharepoint list

Expression

if(equals(item()?['field_3'],true),'Yes','No')

Answer 1

Hi @Dash,

Thanks for reaching out to us. We are very pleased to support you.

According to the formula you provided, it is likely that item()?['field_3'] to get the value of the column is empty resulting in the formula results only return No, you can output the value in the select step.

In my internal tests, I use the column names directly to get the column values (note that spaces should be omitted if there are spaces in the list name) and it works fine. You can also try my formula:

if(equals(item()?['Lightislighted'],true),'Yes','No')

Here is my test result:

If you have any questions, please do not hesitate to contact me.

Moreover, if the issue can be fixed successfully, please click "Accept Answer" so that we can better archive the case and the other community members who are suffering the same issue can benefit from it.

Your kind contribution is much appreciated.