I am a novice power automate user and I am trying to automate more processes within my team. Beating my head against the wall with this issue:
We have an excel file of data. Example headers: Name, Company, Status, Date, Region, Email
We are manually filtering data and creating reports for dozens of teams because they're not allowed access to the main excel file or data that is not related to their accounts.
Is it possible to set up a flow to:
Query the excel file (example, show me all rows where the Company=Microsoft)
Send all matching rows to a List
Stay up to date on it's own (schedule it on recurrence is totally fine) - we'd need to account for modifications, deletes and additions as the excel data is updated often.
I want to duplicate the flow several times so I can provide each team their own list to view.
Thank you in advance for any help!
