Hey everyone
I am very new to power automate and not an IT expert.
I am trying to create a work flow retrieving an excerpt from an excel table once every week and send this table per mail.
The workflow should only filter entries in the table added within the last 7 days (Date of Receipt not older than 7 days), create a table containing all the headers except "number" and add this table to a mail.
The source excel table is deposited in a group looks abit like this:
| Number | Product | Date of receipt | Due date | Task |
| 99990 | Apples | 2021-09-10 | 2021-09-17 | Make Pie |
| 99991 | Cheese | 2021-09-17 | 2021-09-24 | Buy cracker |
| 99992 | Coffee | 2021-09-22 | 2021-09-29 | survive |
| 99993 | Balloons | 2021-10-02 | 2021-10-09 | party |
| 99994 | bluebrix | 2021-10-22 | 2021-10-29 | build miniature |
| 99995 | Cats | 2021-11-03 | 2021-11-10 | make catvideos |
| 99996 | Baboons | 2021-11-04 | 2021-11-21 | run away |
Could you give me a walkthrough how to build the workflow step by step?