Name | Sunday | Monday | Tuesday | Wednesday | Thursd | |
Ishtiaque Ahmad | Y | Y | Y | Y | Y | |
nusrat.jahan | Nusrat Jahan | Y | Y | Y | ||
tanvir.hossain | Tanvir Hossain | Y | Y | |||
mostofa.monower | Mostofa Monower | Y | Y | Y | ||
mohammad.parvez | Mohammad Parvez | Y | Y | |||
shuva.talukder | Shuva Talukder | Y | Y | |||
muntasir.shajib | Muntasir | |||||
tapan.roy | Tapan | Y | Y | Y | ||
abdullah.zubayer | Zubayer | Y | Y | Y | ||
saiful.hasa | Hasan | Y | Y | Y | ||
rahman.novel | Novel | Y | Y | Y | Y |
*Y= Work from home
we are doing a roster schedule in excel online file , not we want to create a schedule flow where if its written "Y" it will send a notification to the users that we have to do work from home today.
If this is an excel online file, then I would recommend moving the data to SharePoint and working from there.
Anyway, try this (and if it doesn't work, try messing with it a little):
That's it, mate ... if the Y values are true booleans you can make it a boolean variable instead.
Also, you OK with those email addresses being on the forum?
Anyway, if you can't get it to work, come back with some flow screenshots, mate, and someone here (maybe me) will sort you out good. 👍