Hi,
I need help in creating a Scheduled Power Automate Flow using Excel Data in Outlook.
I have the following Columns in a Table. Want to use AND Condition to check in the Column has Pending / In Progress of a task and then another column with Days of week Monday / Tuesday/ Wednesday .... and then send an email in Outlook with the data in each Row details with respect to Task. For each task there will be 3 set of people responsible.
The email has to be sent in To to all 3, 3 emails IDs will be in 3 different columns.
Task Details : Descriptions of the Tasks
Task Status: Pending, In Progress,
Reminders : Daily, Monday, Tuesday, Wednesday,.....etc.
I have tried many videos and blog posts, saw different methods, looked simple and complex but not able to get the result properly.
For every flow I tried to create Flow triggers for the Status as Completed tasks not the Pending and In Progress, also it does not the check the another AND condition Monday.
This I am doing as AND will work only for two same types of values.
Attached a Tasks Table for Example.
Also help me with 2/3 OR conditions and sending row wise data in Excel in outlook email.
Kindly help me in this regard. Let me know if you need any other details from me or missing in my explanation.
Thank you very much in advance.
