Concat multiple boolean fields with separator

[RaulSG]

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.

[Paulie78 · Accepted solution]

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 😘

[RaulSG]

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