Using Power Automate and Excel to Send Status Emails Based on Multiple Columns
In this video, we examine a more complicated Excel file with a separate column for each month’s training status. We want to send a consolidated email to each manager showing the training that is due for any of the months. We first try an OData query, but Power Automate will only let us work with one column when we have an Excel data source. So we use a custom Excel column with the TEXTJOIN() function. That along with sorting by supervisor email and sending a new email each time we change supervisors within in the loop does the trick.