Power Automate filter Graph API call

Question

Power Automate filter Graph API call

Chris Mancey (Group) 226

I'm using Power Automate to make Graph API call to the Groups end point

User's image

This works except when I look at the results I realised that the filter was beign applied to the first instance of displayName. How can I adjust the filter so that it returns results from the second displayName inside the AssignedLabel?

User's image

Thanks

Chris Mancey (Group) 226 Reputation points

2023-06-07T16:30:53.63+00:00

I should also point out that the reason for this is to reduce the number of items being pulled in as we have over 100k groups in our tenant so I can't pull everything in and filter from there as it breached the 100k item limit for a premium account.

Alternatively is there a way to split the API call to perform multiple calls to get roung this 100k limit, i tried using $Skip but it tells me that it's unsupported.
TH-4749-MSFT 3,315 Reputation points

2023-06-07T18:11:22.08+00:00

Hi Chris Mancey (Group),

Thanks for reaching out. You can apply the filter as follows:

https://graph.microsoft.com/beta/groups?$filter=assignedLabels/any(s:s/displayName eq 'General').

You can find more info on Graph filtering here.

Please note the filter may not be supported for all properties.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.
Chris Mancey (Group) 226 Reputation points

2023-06-08T07:08:13.25+00:00

Unfortunately that resulted in an error
Chris Mancey (Group) 226 Reputation points

2023-06-08T07:26:42.0433333+00:00
The odd thing is that if I change it to use the labelId instead of the displayName it works so looks like it still gets hung up on the first displayName field.

I will continue using the labelID field

https://graph.microsoft.com/beta/groups?$select=id,displayname,assignedLabels&$filter=assignedLabels/any(s:s/labelId eq '4637s5cc-wd1f-7ad6-u681-89x0f1c6f3d8')

2 answers

Your answer

Chris Mancey (Group) 226 Reputation points

2023-06-07T16:30:53.63+00:00

I should also point out that the reason for this is to reduce the number of items being pulled in as we have over 100k groups in our tenant so I can't pull everything in and filter from there as it breached the 100k item limit for a premium account.

Alternatively is there a way to split the API call to perform multiple calls to get roung this 100k limit, i tried using $Skip but it tells me that it's unsupported.
TH-4749-MSFT 3,315 Reputation points

2023-06-07T18:11:22.08+00:00

Hi Chris Mancey (Group),

Thanks for reaching out. You can apply the filter as follows:

https://graph.microsoft.com/beta/groups?$filter=assignedLabels/any(s:s/displayName eq 'General').

You can find more info on Graph filtering here.

Please note the filter may not be supported for all properties.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.
Chris Mancey (Group) 226 Reputation points

2023-06-08T07:08:13.25+00:00

Unfortunately that resulted in an error
Chris Mancey (Group) 226 Reputation points

2023-06-08T07:26:42.0433333+00:00

The odd thing is that if I change it to use the labelId instead of the displayName it works so looks like it still gets hung up on the first displayName field.

I will continue using the labelID field

https://graph.microsoft.com/beta/groups?$select=id,displayname,assignedLabels&$filter=assignedLabels/any(s:s/labelId eq '4637s5cc-wd1f-7ad6-u681-89x0f1c6f3d8')

Answer 1

Hi Chris Mancey (Group),

Thanks for your response. As mentioned in my previous post filtering may not work for all properties. You can try other operators to see if those work with the assignedLabels/displayName property. You can find more information on filter operators here. I would also suggest that you post your comment and feedback in the Graph feedback forum.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.

Answer 2

TH-4749-MSFT 3,315

Hi Chris Mancey (Group),

Good Day. Hope all is well

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.

TH-4749-MSFT 3,315 Reputation points

2023-06-12T14:53:29.0033333+00:00

Hi Chris Mancey (Group),

Good Day. Hope all is well

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.

Share via

Power Automate filter Graph API call

2 answers

Your answer