Unanswered

Flow -Sharepoint Odata filter problem with multiple lines of text colum

(0) Share

Report

Posted on by Paul_00

Hi All,

I need to filter some SharePoint data using 'multiple lines of text' columns. For that one i have added that column in filter query(flow -SharePoint get items). I am getting this error ''The field 'Body' of type 'Note' cannot be used in the query filter expression"

Is it possible to filter SharePoint data using this column? Please help on this.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (1)

Report

Hi @Paul_00 ,

The function to filter Query on a Multiple line of text type column is not supported in Microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

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

Best regards,

Alice

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

Was this reply helpful? Yes No
Paul_00 19 on at

Like (0)

Report

Hi All,

Can anyone please suggest any alternatives. Thanks in advance!!!

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

Maybe use REST API to query SharePoint Search and add the field as a managed property and then iterate over the results, sounds like a bit of work tho 🙂

Was this reply helpful? Yes No