I have an excel file that is going to be updated as we order material for our job. When we order material we will enter an estimated delivery date in a column. I want to use power automate to automatically send an email to our team a day before letting them know what’s expected to deliver the next day. I’ve attached screenshots of what I have created in power automate so far. I’m not very great with this, I just started learning about it, so I definitely could use some help. Thanks so much.
Unfortunately the pictures may or may not ever come :-( .
Can you walk me through what you have?
My expectation based only on the details I see there is that
1. Run a Reoccuring flow every day
2. Have it read the excel Table (Get Items)
--possibly filter based on tomorrows date
3. Either... send 1 email with all thing for tomorrow
or send one email for each .. .group of items? in case you need to send addresses or something to
the right department.
Now if you want to send them all in one like HTML table thats easy enough
If you need to break down the stuff going out tomorrow, in any way, I'd need to understand that to add in the logic.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.