You’re offline. This is a read only version of the page.
Announcements
114
In the 2 steps shown below, I am using the Excel Online action, List rows in table, to bring in specific rows from a spreadsheet stored on Teams. You can see I am using a Filter query. Then, I would like to Get Items from a SharePoint list. I want to filter the SharePoint items based on the items filtered from Excel online using the eKey.
In this flow, I manually keyed in a value to make sure that I have the column name correct, and what is shown does work. But, I'm having trouble when I try to make it more dynamic and use the eKeys from Excel.
When I change it to this, I get this error. The expression "eKey eq 142xxxxxxxx0" is not valid. Creating query failed. I tried putting single quotes around the eKey dynamic content but that did not work.
Then, I thought that I might need to create a concatenated string to feed into the query, so I added in a Select action and a Compose (using a join expression), and this works with one ekey.
But, when my Excel file has more than one eKey the flow completes successfully but nothing is returned in the output.
NOTE
One of my original solutions was correct. The 2nd screenshot with quotes around the dynamic content did work. Not sure why it didn't work the first time I tried it.
Share
Report
All responses (
Answers (
