You’re offline. This is a read only version of the page.
21
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.
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
Totally agree! sadly it isn't possible
How ever I solve my request, by adding a column on my query that verify if the date is the EOM or not, and also is filtered only by max creation date. So on my flow first I deleted those items that aren't EOM and creates the items resulted from the query, that way everyday the flow just delete and create fewer items
Share
Report
All responses (
Answers (
I receive every workday (M-F) an email with a PDF that contains a table with the sales from the day beforeWhy? It would be much easier if they would give you access to the data source. Then you can create the Power BI reports much easier, and you could create your end-of-month exports much simpler too.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
