Need help creating the following using power automate:
Using an existing Excel file stored in Share Point
Using an existing Excel file stored in Share Point
- Location: Share Point - The Location
- Document Library: Document
- File: The Special File
- Table: Table 1
- Set up a recurrence of daily
- Sort the table by the 'Date' column
- Sort the table by the 'Fruit' column
- Create 1 email per email address that contains a CSV attachment showing only the rows that pertain to them.
- Only the 'Fruit', 'Chip', 'Date', and 'Email' Columns will be included in their CSV file.
- The email subject should read: "Hello " & the name from the 'Person' column
- The body of the email should read "Hi this is a test"