Hi, I'm using Flow to get an Excel SS from a SP library. I have a table in the SS entitled Master and I want to get that data and push it to a SP list. I can get the flow to find the SS in the library and I can the file Meta Data, When I use the file name or ID I get
What am I missing?
Thanks in advance
Chris
Solved! Go to Solution.
Hi ffox,
When using Get rows action, we are able to create a connection to Dropbox, OneDrive for Business, OneDrive, etc.
But it seems that there is no available connection for SharePoint library.
So I am afraid that we are not able to enter the File name and Table for the Excel file saved on SharePoint library.
Hope this could be a reference for you.
Best regards,
Mabel Mao
Hi ffox,
When using Get rows action, we are able to create a connection to Dropbox, OneDrive for Business, OneDrive, etc.
But it seems that there is no available connection for SharePoint library.
So I am afraid that we are not able to enter the File name and Table for the Excel file saved on SharePoint library.
Hope this could be a reference for you.
Best regards,
Mabel Mao
I dont know if you are aware of, but in the latest deployments, MS Flow team made available the Excel (Business) action library, which includes a function called "List Rows Present in table" or something like that. Thats the action you want to use for reading excel files from a SharePoint document library.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
207 | |
97 | |
60 | |
51 | |
44 |
User | Count |
---|---|
257 | |
160 | |
85 | |
79 | |
58 |