Hi,
I am quite new to power automate, and reaching out to the community if anyone could provide a solution to my query.
The automation that I am trying to develop in PAD is that I receive a weekly email containing an excel attachment, from which I require a hidden sheet where the data is stored.
The datasheet has several columns, with the two keys columns ‘date’ and ‘provider’, I need to only extract data that relates to Provider 1 and insert this into a master sheet and only need to extract rows where the date is greater than the max date for the provider in master file, so in this example I would only extract the rows with a date greater than 18/03/23 for provider 1 from the data sheet and insert it into the master file.
Data Sheet
Date | Provider |
18/03/23 | Provider 1 |
18/03/23 | Provider 2 |
19/03/23 | Provider 1 |
20/03/23 | Provider 1 |
21/03/23 | Provider 3 |
22/03/23 | Provider 1 |
Master file
Date | Provider |
14/03/23 | Provider 1 |
15/03/23 | Provider 1 |
16/03/23 | Provider 1 |
17/03/23 | Provider 1 |
18/03/23 | Provider 1 |
18/03/23 | Provider 4 |
I have currently set up the flow below, where I have managed to unhide the sheet and query the datasheet, in my flow I have saved a copy of the extract which I don’t necessarily need. The issue I am having is trying to find a solution to only extract the ‘query result’ data where the date is greater than the max date for that provider within my master file
Any help on this would be much appreciated
Thanks
Nagin
