We have a manually triggered flow with one input - Select a file. All we want to do is pass the selected filename to the next action. When running the flow from my PC, if I look at the Outputs the filename has populated the 'Select Employee spreadsheet name' field:
When I look at the available dynamic content for the next action I see 'Select Employee spreadsheet' but this is returning the spreadsheet binary content as per the contentBytes field.
I then tried running the flow from my mobile and got a clue as to why this isn't working - it only allows me to select an image file, not a .xlsx:
Can anyone confirm that the File input option is expecting an image file only? If that is the case what other way can I prompt a PC user to select a spreadsheet stored in OneDrive for Business and then use the filename in my next action? I don't want to go down the PowerApps route unless there is no other option...... 😉
Solved! Go to Solution.
Your solution was spot on - many thanks - but it has revealed another issue. I can now correctly define the path+filename of the spreadsheet but it is returning this error:
I am passing the string to the Excel 'List rows present in a table' action to return all the rows in a spreadsheet table. You normally choose the spreadsheet file using the picker in the Action File field, so there must be a difference between that and inserting the same string without using the picker.
Hey ho, another Flow Funny 😉