Power Platform Community Forum Thread Details

Hello,

I am looking for suggestions today, since I am not able to achieve what I am trying to achieve. I am still learning how Flows works and I have some troubles understanding how to work on different files to obtain an output.

I upload every day an updated version of an excel file with multiple rows. Each row contains a variable number of item for a certain date. This excel file covers always the same period of time, let's say the current week and the next one.

Date	Item	Number	Notes
22/02	Item1	3
22/02	Item2	2
23/02	Item3	4
24/02	Item4	21
...	...	...

When I update the excel file, some of these rows may be cancelled or new ones may be created.

I have to find a way to let some users to modify the last column for at least today and tomorrow dates. So I've created a list based on the excel but it's not updating automatically so it's not easy to manage it.

In my mind I would like to do something like:

Update the excel file at 23.59 every day

Export the 'today' date of the list on an excel

Clear the 'today' date from the list

Update the list, keeping the rows already filled, with the data from the excel

Any idea how to do that? Even changing all the process or using other office365 tools?

Thanks,

Categories:

Building flows