Flow get list of rows form excel with ODATA filter

[NikolayErlikh]

Hello EveryOne.

Please could you help me with ODATA and Excel online.

I connect to excel file with located on sharepoint site and I would like to get all rows form it.

How to get all rows by using List rows present in table component with ODATA filter?

I tried:

1. startswith(‘name of employee’, ‘Bob’)
answer: !sAj1K!’)’ or ‘,’ expected at position …
2. startswith(name of employee, ‘Bob’)
answer: !sAj1K!’)’ or ‘,’ expected at position …
3. startswith(“name of employee”, ‘Bob’)
answer: “!LKrqa!Syntax error: character ‘\”‘ is not valid at position …
4. startswith(name_x0020_of_x0020_employee”, ‘Bob’)
answer: “Invalid filter clause: cannot find the ‘name_x0020_of_x0020_employee’ column.
But this column is set in table.

But these are not help.

[v-yuazh-msft · Accepted solution]

Hi @NikolayErlikh,

Please add a "Filter Array" action in the flow, you could refer to screenshot below to create the flow:

The flow would run successfully to filter out the rows as below:

Best regards,

Alice

[NazIM]

Does not work if you have more than 256 records. Has anyone found a way around it?

[gates]

Make sure Pagination is turned on and your value is above the total count of rows in your table. 

[MafazAnsar]

Hi I tried doing the same. the flow ran without any hitch. However the table which I wanted to filter did not get updated event after the flow run. I checked the input and output after test run, it shows that the filtering has indeed happened, however not updated in the table in the excel file

[Anonymous]

Is it possible to use odata to filter on a column with a space in the name?

[nich3play3r]

This is my question, too. I haven't yet figured out how to create an odata query to filter my Excel file, but it seems like that functionality is already built here?

[andresdres]

Esto?

https://www.youtube.com/watch?v=ivpfBnQit0Y&lc=UgygNsSJAaztBcBMJ3Z4AaABAg.9a1CJsoDsDM9a1JCEn73e2