Is there a way to use Power Automate to copy data from a Sharepoint Excel file and create a new Excel file or add the data to an existing table data?
Situation: There is a shared Excel file in Sharepoint that I want to extract if data meets certain criteria (for example, if the row is updated, or if a row is added). I was thinking it would make the job easier if Power Automate could be used instead of going to the file every morning to see if data has been added or updated. Then, if there is new or updated data have Power Automate either create a new table or add to my existing data the new or updated data. Is this possible or am I in the land of make believe?
I'm not familiar with Power Automate. I hoped that since it concerns Excel I might be able to find information from MrExcel users.
Situation: There is a shared Excel file in Sharepoint that I want to extract if data meets certain criteria (for example, if the row is updated, or if a row is added). I was thinking it would make the job easier if Power Automate could be used instead of going to the file every morning to see if data has been added or updated. Then, if there is new or updated data have Power Automate either create a new table or add to my existing data the new or updated data. Is this possible or am I in the land of make believe?
I'm not familiar with Power Automate. I hoped that since it concerns Excel I might be able to find information from MrExcel users.