Answered

Action 'Get_items' failed with 'This query is not valid' error

(0) Share

Report

Posted on by MauriceC

I drafted a SharePoint Weekly News Digest flow based on the steps in this article. Initially I did the flow exactly the way this article detailed it--creating a custom PageType column on the Site Pages list--which worked without issue. I later discovered that there is already a column that I could add that differentiated news articles from other pages on a site--the Promoted State column--a Promoted State value of 2 indicates a news article. So I modified my filter query to include 'Promoted State' eq 2 instead of the PageType filter in the aforementioned thread; however, when I test the flow with the updated query, it fails with the following error details for the Get Items action:

The query is not valid.
clientRequestId: 3d5946e5-dab2-456b-b4b2-8d1f87e4e9b7
serviceRequestId: 3d5946e5-dab2-456b-b4b2-8d1f87e4e9b7

Below are some screenshots with the column I used in the filter, the error details, the actions in the flow and the Get Items action with the filter I used.

Thanks in advance for any help you can provide!

2020-09-24 14_00_54-Testing Ground for IT - Site Pages - By Author.png 2020-09-24 14_03_02-Run History _ Power Automate.png 2020-09-24 14_06_02-Run History _ Power Automate.png 2020-09-24 14_07_14-Edit your flow _ Power Automate.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

MJain 2,450 on at

Like (0)

Report

Hi @MauriceC ,

Please try to use _x0020_ for Promoted State condition as given in the similar thread.

https://powerusers.microsoft.com/t5/Building-Flows/OData-syntax-for-sharepoint-column-with-a-space-Get-Items-action/td-p/147705

Thanks

Was this reply helpful? Yes No
MauriceC 11 on at

Like (0)

Report

Should this portion of the query be written like this now: 'Promoted_x0020_State' eq 2 ?

Was this reply helpful? Yes No
Verified answer

MauriceC 11 on at

Like (0)

Report

I ended up omitting the space in the column name altogether and modified the portion of the query to read:

PromotedState eq 2

The flow ended up working successfully.

Was this reply helpful? Yes No
CU05081748-0 on at

Like (0)

Report

same Issue not sure what else to change. keeps failing on the same flow

Please Help.. Been stuck on this for a couple of days.

Was this reply helpful? Yes No