Question

Set up a Power Automate flow to filter specific Descriptions, namely Submitted homework and Absent, from an Excel sheet. Then, extract the corresponding Names and Numbers and organize this data into a table within an email for sending.

Answer 1

To automate filtering specific descriptions in an Excel sheet, extracting corresponding data, and organizing it into a table for email sending, you can use Power Automate.

Step-by-step explanation:

Power Automate Flow to Filter Descriptions in Excel

To set up a Power Automate flow to filter specific descriptions from an Excel sheet and extract corresponding names and numbers, follow these steps:

1. Create a new flow in Power Automate.
2. Add the 'Excel - Get rows' action and select the Excel workbook.
3. Use a 'Filter array' action to filter rows with descriptions 'Submitted homework' or 'Absent'.
4. Add a 'Select' action to extract the desired columns (Names and Numbers) from the filtered array.
5. Use a 'Create HTML table' action to organize the extracted data into a table within an email.
6. Add the 'Outlook - Send email' action and provide the email details.
7. Save and test the flow.

This Power Automate flow will filter the specified descriptions from the Excel sheet, extract the corresponding data, and organize it into a table within an email for sending.