Hello all!
First let me expose what Im currently doing and what I need, hopefully someone with help me! 🙏
1) I receive every workday (M-F) an email with a PDF that contains a table with the sales from the day before.
- Monday: I get 3 PDF attached (Friday, Saturday and Sunday sales)
- Tuesday: I get 1 PDF attached (Monday sales)
- Wednesday: I get 1 PDF attached (Tuesday sales)
- Thursday : I get 1 PDF attached (Wednesday sales)
- Friday: I get 1 PDF attached (Thursday sales)
2) I have successfully created a Flow that take all the files and save them in to a One Frive folder
3) I have also created a PowerBi report that combines all files and generate daily, monthly and yearly KPI
4) Now I need to create a Sharepoint List with "end of the month" sales for each month, and the most recent date for the current month
I was able to do it with this flow
(The delay is to make sure the dataset finished the update)
So basically I delete all the items and then create them again, which are the steps that take longer
To speed this process I guess I would have to get the Items filtered by "Date" value not being the End of the Month and delete those items exclusively. But i'm not sure how the formula would be
Then I could filter my query and create only the latest Items
