web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint Yes/No colu...
Power Automate
Answered

SharePoint Yes/No column comparison returns false in Condition (Italian tenant)

(0) ShareShare
ReportReport
Posted on by 3

Hi everyone,

I’m having an issue with a Condition in Power Automate when comparing a SharePoint Yes/No column.

 
  • SharePoint column type: Yes/No (Italian UI shows “Sì” / “No”)

  • In my flow, the condition is equals

  • When I run the flow, in the condition debug it evaluates to false, even when I believe the value should match.

 

My confusion is about the value to compare:

Should I compare using Italian labels (“Sì” / “No”) or English values (“Yes” / “No”), since Power Automate actions are in English but my tenant/SharePoint UI is Italian?


Example (simplified):

Condition: equals(<SharePoint Yes/No field>, 'Yes') → evaluates false

I also tried 'Sì' and 'True', but I’m not sure what is correct.

 

Questions:

 
  1. What is the actual value returned by a SharePoint Yes/No field in Power Automate (Boolean true/false, 1/0, or text)?

  2. What is the recommended way to write the condition so it works reliably regardless of language settings?

  3. If needed, how can I convert the field to a Boolean and compare safely?

Any help or best practice would be appreciated. Thanks!

Categories:
I have the same question (0)
  • Verified answer
    David_MA Profile Picture
    14,956 Super User 2026 Season 1 on at
    In the expression builder, search for the expression true or false and insert that into the expression instead of manually typing yes or no. The way you are currently formatting it, it is treating Yes as a string instead of a Boolean value since it is in single quotes.
     
    equals(triggerOutputs()?['body/Assigned'], true)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard