cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
panand99
Level 10

Multiple lines of text filter records

Hello all,

 

I want to filter records to from list with multiple lines of text field. I saw Audrie`s video that will filter out records in single lines of text field.

 

I am using flow from powerapps action.

 

The error I got - 

"The field 'DocumentReaders' of type 'Note' cannot be used in the query filter expression.\r\nclientRequestId: ...
 
 
 
 
3 REPLIES 3
Community Support Team
Community Support Team

Re: Multiple lines of text filter records

Hi @panand99 ,

 

Thanks for sharing the great video.

 

The issue could be reproduced by me. I am afraid that not all the columns are supported in Odata filter query, such as Lookup column, Multiple line of text column, and other multiple selection enabled columns.

 

If you need this feature, please feel free submit your request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

A workaround for your scenario is using the action Filter array instead. I have made the following simple test which is working properly.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
panand99
Level 10

Re: Multiple lines of text filter records

Hi @v-yamao-msft 

 

Thanks for your reply, this is working fine till the select statement. I am not able to add this flow it is saying unable to add service... if I am using its "Response" (It saying it is PREMIUM"). 

reponse premium.png

Community Support Team
Community Support Team

Re: Multiple lines of text filter records

Hi @panand99 ,

 

Which Flow Plan are you using?

 

If you are using Flow Free Plan or Flow for Office 365 and Flow for Dynamics 365, it would be not possible for you to use premium connectors.

 

Please check Connectivity in the following doc on Flow Pricing:

https://preview.flow.microsoft.com/en-us/pricing/

 

Best regards,

Mabel

 

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 357 members 3,760 guests
Please welcome our newest community members: