Share
Report
94Hi,
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
All responses (
Answers (
