PowerApp Gallery filtering based on Azure Group

(0) Share

Report

Posted on by PowerEmployee7

I have the following formula and I'm getting a warning that it can't evaluate the formula becuase the values being compared in the formula aren't the same type. It shows I'm comparing Text with Boolean, but I don't know how to do it any other way. It seems to work fine for now, but am worried it will break as I'm not using it correctly it seems. My goal is to be able to add users to an Azure AD group and then the gallary will only return items if they are within the group. Thanks!!

This is my Gallary formula for "Items"

If(varUser2 = isUserMemberAccountingGroup Or isUserMemberHRGroup, Sort('Open Position',Created,Descending), Sort(Filter('Open Position', 'Created By'.Email = Office365Users.MyProfile().Mail),Created,Ascending))

VarUser2 is

Set(varUser2, User().Email);

And the Groups formula is

Set(isUserMemberAccountingGroup, varUser.Email in Office365Groups.ListGroupMembers("18334207-f414-b70c-d611de1614f2").value.mail);

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerEmployee7，

Yes, the error report is correct.

The variable isUserMemberAccountingGroup is defined as a boolean because you compare varUser with Office365Groups.ListGroupMembers() using in operator.

I will show why the isUserMemberAccountingGroup is a boolean value, here is a simple demo:

User().Email in Office365Groups.ListGroupMembers(MyGroupId).value.mail

Was this reply helpful? Yes No