Answered

Problem with Update Sharepoint List action using Filter Query

(0) Share

Report

Posted on by SteveTaylor

Hi,

I have a flow where I create documents from a Plumsail action which works fine. When I try and update a Sharepoint List to show they have been submitted, the flow works but updates every line as it isn't being filtered. When I need to use the Filter Query action to only update the relevant line, it fails. The key is the 'Company Name' but it fails with the message 'The field 'CompanyName' of type 'Note' cannot be used in the query filter expression.'

The query filter entry I am using is as below, with the full working flow below it (less the filter query entry).

Any help would be greatly appreciated as I am fairly new to Power Automate.

Thanks in advance.

Steve

I have the same question (0)

All responses (3)

Answers (1)

SteveTaylor on at

Like (0)

Report

Re: Problem with Update Sharepoint List action using Filter Query

Screenshot with companyname entry.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,179 Most Valuable Professional on at

Like (0)

Report

Re: Problem with Update Sharepoint List action using Filter Query

Hello @SteveTaylor ,

Filter Query doesn't support filtering on 'Multiple lines of text' SharePoint column. The easiest solution would be to switch the CompanyName to 'Single line of text' if possible.

If not, you'll have to get all items and then filter them using the 'Filter array' action as explained here.

Was this reply helpful? Yes No
SteveTaylor on at

Like (1)

Report

Re: Problem with Update Sharepoint List action using Filter Query

@tom_riha Many thanks - that's worked. I really appreciate your quick reply.

Was this reply helpful? Yes No