web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows True and False express...

Power Automate - Building Flows

Answered

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

(0) Share

Report

Report

Posted on by DT-14120550-0

25

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

User's image

User's image

HTML Table User's image

Sharepoint list User's image

Expression

SQL

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

Categories:

Business Process Flows

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 32,912 Most Valuable Professional on at

Like (0)

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

Hi @DT-14120550-0,

Can you double check you used the correct field name? I see you used field_3, it might be different. You can check this in the inputs of your Select action.

Additionally, you can simplify your expression. Since the field already returns a boolean output, you wouldn't need an equals for the conversion to a string value.

Below is an updated example

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

Test result of that new expression

Was this reply helpful? Yes No
DT-14120550-0 25 on at

Like (0)

Report

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

Hi,

You are correct. I did not realise the column name isnt the same till you pointed it out by reviewing the select output. I also learn the internal name would not change when after editing and hence I thought the display name is the same as internal. I have copy the list from other location and edited the name. Thanks for the great help which took me almost a month figuring it out.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 614 Super User 2025 Season 2

#2

Tomac 401 Moderator

#3

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans