Automation done in Microsoft Power Automate
Budget: €30 – €250 EUR
I need automation done in Microsoft Power Automate with following requirements:
1. At certain time of day, read out excel file from OneDrive. (I've attached sample file here for reference).
2. Check Table 1. If the day under "Completed" is same as today, proceed to step 3, otherwise send an email with some text like "Not completed".
3. If the day is today (hour is not relevant), check the "Status" column also in Table 1. Whatever Status is there, it can be "OK" or "Wrong" or "ignore", send an email with that status word in the subject. Also create PDF file from the excel in the same location, and attach it in the email.
1. At certain time of day, read out excel file from OneDrive. (I've attached sample file here for reference).
2. Check Table 1. If the day under "Completed" is same as today, proceed to step 3, otherwise send an email with some text like "Not completed".
3. If the day is today (hour is not relevant), check the "Status" column also in Table 1. Whatever Status is there, it can be "OK" or "Wrong" or "ignore", send an email with that status word in the subject. Also create PDF file from the excel in the same location, and attach it in the email.