Forum Discussion
Solved
Automated Daily Data Append to SharePoint List or Excel Spreadsheets
I download a report every day that contains data that needs to be split and appended to 18 different Excel spreadsheets stored in SharePoint. The data contains one field used as criteria for the spli...
Lpatterson7 your excel spreadsheet needs to be formatted as a table, then in your flow select the Excel Online (Business) list rows present in a table action.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Thank you for this! It looks pretty simple, but I have not yet mastered Power Automate. I will take some crash courses and try this as soon as I understand it a bit more.
Rob, my data is stored in an Excel Workbook on a SharePoint site. The Workbook has 3 Worksheets, one of which I will be connecting to when retrieving the data. I messed around with the steps you provided but am not seeing "ProviderPractice" (your example: "Practice" as a choice in the Switch. This leads me to believe I am not locating the data properly. Currently I have tried: "Get Worksheets" (excel) and "Get a Row" (Excel). Neither give me the fields to choose from when I am creating the "Switch". I hope this makes sense. Thanks in advance for the help.
Lpatterson7 your excel spreadsheet needs to be formatted as a table, then in your flow select the Excel Online (Business) list rows present in a table action.
Rob
Los Gallardos
Microsoft Power Automate Community Super User