
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,