Forum Discussion

ShriAkshayManke's avatar
ShriAkshayManke
Copper Contributor
May 17, 2024

Filter Results by Splitting Values from Output Receiving from Graph API

Hello All,

 

I am trying to get list of all the users who are having a specific attribute value from AD, this I am doing in PowerApps. Below the code I am using. 

 

 

ClearCollect(
    UserCollection123,
    Table(
        Office365Groups.HttpRequest(
            "https://graph.microsoft.com/v1.0/users?$count=true&$top=999&$filter=extension_extensionAttribute1 eq 'ABC - 123'&$select=displayName",
            "GET",
            ""
        ).value
    )
)

 

 

I am trying to get users who have the attribute value as ABC - 123. This is working fine, and I am getting the list of users. But there are combinations of the attribute for example ABC - 123, DEF - 123, FRT - 123, ABC - 222.

I want to fetch all the users which are having the attribute 123 in the ending. So, this should list out users from ABC - 123, DEF - 123, FRT - 123.

 

Can anyone please help how to achieve this?

 

Thanks,

Akshay

No RepliesBe the first to reply

Resources