Answered

OData Style filter expression in Power automate flow in Power apps

(0) Share

Report

Posted on by raah0705

Hi everyone!

I was investigating how to use the filter rows to use the List rows action. I want to filter the data with Id column value. But I didn't find anything that could help me. e.g Id =30, so All records will be filtered whose Id is equal to 30.

I tried using $filter expression, but It did not work.

The filter rows says. Enter an OData style filter expression to limit which rows are listed.

I try with.

Id eq 32

$filter=Id =32

I want to filter all the table data whose Id is equal to 32.

Please help me to resolve this issue.

Thanks for your answers. Thanks in Advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report
Hi @raah0705,

You don't need to specify $filter in the Filter area as that's already implied.

Your filter should look like:

<<columnSchemaName>> eq 32

When specifying a column, you need to specify its Schema Name. You can retrieve this in the maker portal by:

Navigating to your table, then select columns.

Find your column and click the 3 ellipses

Select Advanced

Select Tools

Click Copy Schema Name

Paste that into the Filter expression in Power Automate

(sorry for poor quality photo/highlighting, on a mobile device at the moment)

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
raah0705 20 on at

Like (0)

Report

Hi @ChrisPiasecki ,

Thank you for your reply. I verified it using the same schema name. In the run time, I got below error.

Could not find a property named 'pit_EmpId' on type 'Microsoft.Dynamics.CRM.pit_tbltempdata'.
This "pit_EmpId" is actual schema column name for my table.

Please guide me on this. Thanks

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @raah0705,

My apologies, minor mix up from my side. Instead of the schema name, Copy Logical Name. This will be the same as the schema name but all in lowercase (the OData expression is case sensitive).

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
raah0705 20 on at

Like (0)

Report

Hi @ChrisPiasecki ,

Thanks. I tried using logical name with lower case letter, but unfortunately its not working for me. It is giving me same error.

Could not find a property named 'pit_empId' on type 'Microsoft.Dynamics.CRM.pit_tbltempdata'.

Please guide me on this. Thanks for your help

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @raah0705,

Looks like the I is still uppercase according to the error message. Try entering:

pit_empid eq 32

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
raah0705 20 on at

Like (0)

Report

Hi @ChrisPiasecki ,

Yes, that works. Thank you so much for solution.

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

No problem @raah0705 -- glad we got it working for you!

Was this reply helpful? Yes No