web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multiple lines of text...
Power Automate
Unanswered

Multiple lines of text filter records

(0) ShareShare
ReportReport
Posted on by 641

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: ...
 
 
 
 
Categories:
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    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

     

  • panand99 Profile Picture
    641 on at

    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

  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 130

Last 30 days Overall leaderboard