Hi @ahmadbutt
Yes, it's possible. Let's do it! 🙂
Before we start, the Excel connector doesn't have a "Created or Modified" trigger, so you have to do some extra work to find the information. If you can use a SharePoint list to store your data (not the file) this you,'ll save a lot of work since it does this for you. It's up to you, but since you asked for excel, let's take that path :).
First, the values where you're storing the information should be Excel tables. Make sure that they are otherwise Flow can't really fetch the information.
After that, you need to run a Power Automation just once to add an id column to the table. Just create a Power Automation as follows:
OK, now we have or Excel formatted so that Power Automation can manage it better.
If you're always using these 3 columns then it's easy. Just create a Power Automation that triggers periodically (Schedule trigger) and check, using the ID column created before if the value in the column is 10 or 100. Something like this:
Now if you want to update data in the same excel, you need to do the same steps:
1. Ensure that the locations you want to update data are tables.
2. Add an ID column
Then you can update the values when you run the Power Automation.
All of this makes sense? It looks complicated but it isn't. If I missed something or if you don't understand some part of it, let me know, and we'll figure this out together :).
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
