cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RaulSG
Frequent Visitor

Concat multiple boolean fields with separator

Hello community!

I have this situation: in a SharePoint list, I have 5 boolean fields each for one day of the week from Monday to Friday. I need to present in an Outlook mail in a flow the following text:

  • Selected days: Monday, Thursday (if for example the fields Monday and Thursday are checked on the record of the list)

o

  • Selected days: Tuesday, Thursday, Friday (if for example the fields Tuesday, Thursday and Friday are checked on the record of the list)

I have tried with the CONCAT and CONCATENATE functions in an expression but I can't get the desired result. Does anyone know a method to do it?
Thank you very much.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

Hi @RaulSG 

Interesting question. You can do it like this:

https://youtu.be/GnJZQz0FvvI

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

View solution in original post

2 REPLIES 2
Paulie78
Super User
Super User

Hi @RaulSG 

Interesting question. You can do it like this:

https://youtu.be/GnJZQz0FvvI

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

View solution in original post

RaulSG
Frequent Visitor

Thank you very much @Paulie78 !
Your answer is perfect and great, with video included... amazing!!!!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (947)