
Announcements
Hi all!
So I have the following scenario: One excel doc with a table and one blank csv, both on SharePoint. I would like to have the csv automatically update based on the changes I make in the excel doc. These can be exact copies of each other, but bonus points if there is a way to only have some columns copied over to the csv. For further clarification I want any change made to any cell on the excel table to be reflected on the csv, automatically (or at the very least set to update periodically). Is this possible using Power Automate? I thought I could get by by using Get Data and Power Queries on Excel, but I can't figure out how to source data from another file on SharePoint, and even if I could there would probably be permissions issues. Thanks in advance!
Your probally going to save a lot of time using something like Encodian connector - you could either run on a schedule or every time you modify the excel file depending on how many runs you pay for. They have a converter that can convert from excel to csv.