Share via

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

Dash 20 Reputation points
2024-12-14T05:48:10.17+00:00

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 overviewUser's image

User's image

User's image

HTML TableUser's image

Sharepoint listUser's image

Expression

if(equals(item()?['field_3'],true),'Yes','No')
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,278 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,158 questions
Accepted answer
  1. Ling Zhou_MSFT 19,940 Reputation points Microsoft Vendor
    2024-12-16T02:44:33.18+00:00

    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.

    User's image

    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: User's image

    User's image

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.