Hi All,
I am trying to get a boolean value of a selected textbox by comparing it with a security group from o355. However not all the users from the o365 security group is been populated.
Lower(SearchUser_1.Selected.Email) in Lower(Concat(Office365Groups.ListGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX").value,mail &", "))
Any suggestion?
Solved! Go to Solution.
Hi @avizhome ,
Could you please share a bit more about your issue?
Do you mean that the Office365Groups.ListGroupMembers() function could not list all users from your Security Group?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
On your side, please modify your formula as below:
Lower(SearchUser_1.Selected.Email) in Lower(
Concat(
Office365Groups.ListGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX", {'$top': 999}).value, // specify 999 for the '$top' attribute
mail & ";"
)
)
If the issue still exists, please consider take a try to use AzureAD.GetGroupMembers() function to achieve your needs. Please try the following formula:
Lower(SearchUser_1.Selected.Email) in Lower(
Concat(
AzureAD.GetGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX").value,
mail & ";"
)
)
Please take a try with above solution, then check if the issue is solved.
Best regards,
Hi @avizhome ,
Could you please share a bit more about your issue?
Do you mean that the Office365Groups.ListGroupMembers() function could not list all users from your Security Group?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
On your side, please modify your formula as below:
Lower(SearchUser_1.Selected.Email) in Lower(
Concat(
Office365Groups.ListGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX", {'$top': 999}).value, // specify 999 for the '$top' attribute
mail & ";"
)
)
If the issue still exists, please consider take a try to use AzureAD.GetGroupMembers() function to achieve your needs. Please try the following formula:
Lower(SearchUser_1.Selected.Email) in Lower(
Concat(
AzureAD.GetGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX").value,
mail & ";"
)
)
Please take a try with above solution, then check if the issue is solved.
Best regards,
Thanks @v-xida-msft ,
You are an absolute lifesaver 🙂
I am pretty new to power apps and have been struggling with this for a while.
I have got a toggle button that gets enable if the selected user is part of a security group. It was sort of working with my code but was not showing all users from that particular group.
With your code, I can see all the members now.
Lower(SearchUser_1.Selected.Email) in Lower(
Concat(
Office365Groups.ListGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX", {'$top': 999}).value, // specify 999 for the '$top' attribute
mail & ";"
)
)
So what does that $top:999 do? is it only searching the top 999 users from the security group?
I also tried with the AzureAD.Groupmemebers() as you suggested but that too is not populated all the users from the security group.
Thanks for your help!
User | Count |
---|---|
175 | |
111 | |
86 | |
44 | |
42 |
User | Count |
---|---|
228 | |
116 | |
115 | |
72 | |
67 |