You’re offline. This is a read only version of the page.
58
Hello,
On my SharePoint List I have a Yes/No column with 10 entries.
How can do a Power Automate Flow that does a condition that if any of the entries is yes, it will send an email.
Hi @annoying
HAHAHAHAH....I just start to check your details but you already make it works.
Anyway, thank you for all your time and patience. 😀
Have a nice day!
Best regards,
Anna
Hi @annoying
Thank you for your further information.
Yes, that's similar. Here you are:
List:
Flow :
if(contains(variables('Choices'),'Yes'),'Yes','No')
After testing:
Hope it helps.
Best regards,
Anna
Hello @v-duann-msft !
What I mean was that for a column, any of it is Yes (as seen in the picture, the Jan column). Does it work the same?
Hi @annoying
Thank you for posting.
According to your description, you would like to send email as long as one Yes/No column is equal to Yes.
Please help to check is that what you want as below:
I create 5 Yes/No columns in my list, you can create 10. The steps are similar.
Flow overview:
if(contains(variables('response'),'True'),'yes','no')
If any entity equals to Ture, it returns yes.
If you have any further request, please feel free to reply me.
Hope the content above may help you.
Best regards,
Anna
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
