You’re offline. This is a read only version of the page.
Announcements
94
Hi,
My flow does the following
1) Takes email spreadsheet attachment and saves it to SharePoint with a unique file name.
2) Gets the SharePoint Excel file and adds a table based on a custom range and name i specify as the attachment is without a table.
When i attempt 'List rows present in a table' i cannot point directly to the file as each spreadsheet saved has a unique name, so instead i add the file Full Path from the 'get file properties' step. This means there is no Table selection in the drop down and i have to manually type the name of the Table. Table1
When i then try to 'create item' in the SharePoint List i get no excel table column headers to chose from so i cannot populate this list.
I know that if if could point to the file through the directory it would see the table, i could select the table and the column headers would show. The problem here seems to be that as the file saves each time with a unique name (todays date-attachment name) that i am unable to point to the file and this causes an issue where the table has to be manually specified and in turn no longer shows the headers for me to match Excel table to SP List...
Please let me know how to work around this? thanks
You can point to a dynamic file name in the list rows present in a table if you encode the path to the file using EncodeURIComponent() function. IF the Table always uses the same columns then you can add it once manually and then replace the location and file name with encoded dynamic content. If the columns change from file to file then you need to create each row as an Item record with all the named columns.
Share
Report
All responses (
Answers (
