cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
brikah
Level: Power Up

how to Get Items Filter by dynamic content ?

I'm trying to get items from sharepoint list using the dynamic content .

the Filter Query it is Succeed when I do like the Image below:

 

Capture 1.PNG

 

but when I trying with dynamic content it fails like image below :

 

Capture2.PNG

 

plz any help 🙂

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to Get Items Filter by dynamic content ?

Hi @brikah,

 

It seems you are trying to query the People or group field using OData filter.

Currently that is not supported, as the document states:

"

Query for users

In the SharePoint REST service, users are represented by the user's friendly (display) name, and not their alias or domain\alias combination. Therefore, you must construct user queries against users' friendly names.

Note:

 Membership-based user queries are not supported.

Usage of the Current operator to do queries using the ID of the current user is not supported.

"

You may take a look at the details for query option in the TechNet WIKI below:

SharePoint 2013: Using REST API For Selecting, Filtering, Sorting And Pagination in SharePoint list

 

Further, using the $expand option should be able to get the People or group field details in OData query, but currently this is not supported under the SharePoint Get items Action:

SharePoint 2013: Get User Details from Person or Group field using REST API

If you would like this option to be supported under the SharePoint Get Items action, then please consider submit this as an idea.

 

Regards,

Michael

Community Support Team _ Michael Shao
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

3 REPLIES 3
Super User
Super User

Re: how to Get Items Filter by dynamic content ?

Hello @brikah,

 

The reason why the second procedure fail is because ODATA does not understand the format you are using. If you're not familiar with ODATA in SharePoint, the following link has some information you can read.

 

Use OData query operations in SharePoint REST requests


Fausto Capellan, Jr


Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

Proud to be a Flownaut!


Community Support Team
Community Support Team

Re: how to Get Items Filter by dynamic content ?

Hi @brikah,

 

It seems you are trying to query the People or group field using OData filter.

Currently that is not supported, as the document states:

"

Query for users

In the SharePoint REST service, users are represented by the user's friendly (display) name, and not their alias or domain\alias combination. Therefore, you must construct user queries against users' friendly names.

Note:

 Membership-based user queries are not supported.

Usage of the Current operator to do queries using the ID of the current user is not supported.

"

You may take a look at the details for query option in the TechNet WIKI below:

SharePoint 2013: Using REST API For Selecting, Filtering, Sorting And Pagination in SharePoint list

 

Further, using the $expand option should be able to get the People or group field details in OData query, but currently this is not supported under the SharePoint Get items Action:

SharePoint 2013: Get User Details from Person or Group field using REST API

If you would like this option to be supported under the SharePoint Get Items action, then please consider submit this as an idea.

 

Regards,

Michael

Community Support Team _ Michael Shao
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

Rodolfo1840
Level: Powered On

Re: how to Get Items Filter by dynamic content ?

Is it still not possible?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 208 members 6,357 guests
Please welcome our newest community members: