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

Community site session details

Session Id : 2TO7zYPJNwXkdjWiAiIhgr
Power Automate - Building Flows
Answered

Converting Excel Yes/No to SharePoint List Boolean

Like (0) ShareShare
ReportReport
Posted on 29 Sep 2021 11:50:16 by 9

Hello guys,

 

I have used the Power Users forum a lot as a viewer, which helped a lot. So first of all, thank you!

 

But today is the day I cannot find any solution to my problem, so I need to ask you directly.

 

I am using a flow that checks an Excel table for changes in the existing items as well as new items. It will then update a SharePoint list by adding the new items or updating the existing ones. So far, so good. I have figured out converting dates successfully, but I simply won't make it convert the German "Ja" or "Nein" to boolean 'true' or 'false'. Boolean fields stay empty or rather 'false', no matter what I do.

 

But Thomas!, I hear you saying. There is a whole lot of threads refering to the exact same question! And yes, indeed, there is. Only that not a single solution has worked for me. I apologize, though, should I have missed one. My current solution is:

 

if(equals(items('Auf_alle_anwenden')?['MwSt_x002e_x0028_2_x0029_'],'Ja'),true,false)
 
'Auf_alle_anwenden' refers to the action right after reading the Excel table, which the above formula is a part of:
AmazingThomas_1-1632915291654.png

We are right at the bottom at 'Element aktualisieren' or 'Element erstellen 2'.

 
I have tried every other formula I can think of, with operators instead of 'equals', with another conversion of 'Ja' to string, ... I have also tried to enter 'true' and 'false' as an expression instead of typing it, as shown in this thread. I have also tried to throw the value of 'MwSt_x002e_x0028_2_x0029_' in a variable and use the variable to update the SharePoint list. No success.
 
Thank you for your help!
 
Thomas
  • Verified answer
    AmazingThomas Profile Picture
    9 on 29 Sep 2021 at 14:19:09
    Re: Converting Excel Yes/No to SharePoint List Boolean

    Well, this is what I call irony. I checked out this post that I only found because it was recommended next to mine. The 'Compose' method actually works. Case solved, Watson!

     

    Thomas

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete