Hello,
I am quite new in building Flows and I have managed to figure out the basic needs for my team at work, but there is one thing that would make our lives much easier, unfortunately, I can't figure out how to set the flow or if it is even possible.
We are a team of 25 people and we are all using our own excel "request tracker" it is saved on our share drive so the boss can keep finding who did which ticket. We thought it would be enough to just ask in chat, so the boss does not have to go through each file separately, but sometimes people are offline/on vacation and therefore they would not respond.
So my question is, is it possible to build a flow, that would search through all the excel files for a specific row? The excels are formatted more or less the same way and I would need it to search based on a private number of employee (column number 4) or last name (column number 5 and preferably name too column number 6), and then copy the column from the file where it is to somewhere where my boss could easily see who worked on that. The private number is never the same unless two people were working on different things for the same person so it could search for more results, but that is alright as long as we don't have to go through hundreds of rows in 25 files. The last name and name is very often the same for different people, so the number would work better in my opinion.
I hope I explained well, as I said, I am quite new. I would appreciate any help or suggestions on how to do this differently - my other idea was to transfer the excels to SharePoint list, and have it done automatically that each new row that we will write in any document would transfer there, so my boss would only have to search in one file, but honestly, I did not figure that out either properly.
Thank you!
