cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brice235i
Level 8

Get items Filter query choice - not working

Hello I am trying to Get items where the 'Event Type' choice column (SharePoint Calendar) is equal to a specific type...  When I go to add the Query, there is no Dynamic content available.  Therefore I typed in: "Event Type eq 'xxxxxx'

Unfortunately the flow failed.

{
"status": 400,
  "message": "The expression \"Event Type eq 'HSE Superintendent Monthly Notification'\" is not valid.\r\nclientRequestId: 69794d5a-4321-45d2-a6e4-ff609d0f19cf\r\nserviceRequestId: 5b0da69e-a065-7000-83e5-cd6d30ccd4ae"
}
 
Just wondering what the syntax should be to get this filter working.  Thank you!FilterQuery.PNG
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Get items Filter query choice - not working

Hi @Brice235i,

 

Because this Column name contains a space, when Odata is queried, the name it displays is not the original name.

It uses some special characters instead of spaces:

10.PNG

You could use Get items directly to get the contents of the Body, observe what the name is displayed here, and then configure it in the Filter query:

11.PNG

Please take a try and let me know if issue still exists.

 

Best Regards,

Barry

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

View solution in original post

5 REPLIES 5
Community Support Team
Community Support Team

Re: Get items Filter query choice - not working

Hi @Brice235i,

 

Because this Column name contains a space, when Odata is queried, the name it displays is not the original name.

It uses some special characters instead of spaces:

10.PNG

You could use Get items directly to get the contents of the Body, observe what the name is displayed here, and then configure it in the Filter query:

11.PNG

Please take a try and let me know if issue still exists.

 

Best Regards,

Barry

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

View solution in original post

Highlighted
Brice235i
Level 8

Re: Get items Filter query choice - not working

Thank you Barry!

maxtarneberg
Level: Powered On

Re: Get items Filter query choice - not working

Hi,

 

Hopefully you can help on this...

 

I am a getting a related issue while using filter query.

GrowerName is my column name, and the name Cruickshank is the value that is passed from PowerApps, which I wish to filter by.

 

The outcome is bizarre because it says the "Column 'Cruickshank' does not exist. 

Futhermore, this flow is copied from am existing flow, and only the column in Filter Query has been altered, and everything continues to work as expected on the original flow.

 

How could this be remedied please?

 

 

 

Capture.PNGCapture2.PNG

Brice235i
Level 8

Re: Get items Filter query choice - not working

Hello, isn't your column name GrowerName?  Have you tried GrowerName='Cruikshanks' as the filter to isolate the problem is on the PowerApp end?  

maxtarneberg
Level: Powered On

Re: Get items Filter query choice - not working

@Brice235i 

Hi, thanks for your reply.

 

Yes, my column is called GrowerName.

I tried GrowerName='Cruikshanks' as you suggested, and the flow ran successfully.

However, my filter needs to be defined at the powerapps end.

 

I am using a Datacardvalue.Text as my filter query parameter within PA, which does indeed contain the text "Cruickshank" (or other grower), when the trigger button is clicked.

 

It seems though, that I needed to enclose the GetItems_FilterQuery in ' (single apostrophes)

 

My flow now runs as intended.

 

Thank you for your help

 

 

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: 446 members 4,364 guests
Please welcome our newest community members: