Power Platform Community Forum Thread Details

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.