Microsoft Power Automate | Read Excel and send Email | Tutorial

Reading an Excel table and sending an email from Microsoft Power Automate fits in one instant flow, with a condition that mails you about every sale above 6500.
Join my community, 7-day free trial: iloveautomation.ai/community

The data is an Excel table with five rows: An ID, a name and a sale for each person, such as Angela's 7,000 and Bill's 11,000. Create an instant flow, name it "Excel data condition" and pick the manual trigger. Add the Excel Online action "List rows present in a table", then choose OneDrive as the location, the document library, the file and the table in the dropdowns. Add "Apply to each" from Control and select "value" as the output, so the flow handles one row at a time. Inside the loop, add a "Condition" where the sale is greater than 6500. The Sale column arrives as text, so replace the dynamic content with the expression float(items('Apply_to_each')?['Sale']) before the comparison works.

TOP LEARNINGS
🔹 Import Excel rows into a cloud flow
🔹 Loop through the rows with "Apply to each"
🔹 Convert the Sale column with float() before you compare it

In the yes branch, send yourself a notification email. The subject reads "Remember to send wine to" followed by the name and the sale ID, and the body is "Regards myself". Click "Save", then "Test", and run the flow manually. Two emails arrive in the mail client, one for Angela and one for Bill, because only their sales pass 6500. The Excel file can also sit on a SharePoint site instead of OneDrive; the same dropdowns in "List rows present in a table" point to it.

Power Automate Tutorial for Beginners: youtu.be/omQ-fAF4QpI
Power Automate Use Cases (playlist): youtube.com/playlist?list=PLXXz88_TPiHqGlJoWhBD…

CHAPTERS
0:00 Read Excel and send an email in Power Automate
0:20 Inspecting the data for our use case
1:00 Create a new Flow
1:38 List rows present in a table
2:22 Apply to each
3:20 Condition (if/else)
05:25 Send an Email (notification)

#PowerAutomate #Automation #Excel