Remove invalid user Error.

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

in my app i want to display only current available users from list aswell as O365 group.

Previously in my list i stored some users value . But now they are not a member in O365 groups.

So i want to display only available users from O365 group.

If(Concat(List.RecipientEmail,ThisRecord.RecipientEmail) in Concat(MembersfromSG.mail,mail),
If(Dropdown2.SelectedText.Value="All",FirstN(SortByColumns(AddColumns(GroupBy(Filter(List,Month(CreatedonDate)=Dropdown3.Selected.ID,Year(CreatedonDate)=Dropdown6.Selected.ID&&Category="Appreciation"),"RecipientName","RecipientEmail","Details1"),"Count",CountRows(Details1)),"Count",Descending),5),FirstN(SortByColumns(AddColumns(GroupBy(Filter(List,Month(CreatedonDate)=Dropdown3.Selected.ID,Year(CreatedonDate)=Dropdown6.Selected.ID&&Department=Dropdown2.Selected.Value&&Category="Appreciation"),"RecipientName","RecipientEmail","Details1"),"Count",CountRows(Details1)),"Count",Descending),5)))

this is a formula what i used.

I want to make any change in my formula?

Thanks,

Dhinesh

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Therese Youssef Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dhinesh28R,

You need to connect Office 365 to PowerApps, then you can use SearchUser function to filter users as you want to display.

For more information, see: Overview of the Office 365 Users connection - Power Apps | Microsoft Docs

If this answers your question, please mark your post as Solved.

Hope the above content may help you.
Thanks.

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Therese-Youssef ,
Already am using O365 group.. Now actually what i want is i need to remove users who all are not a member of o365 group and then display only available users from 0365.

Thanks,
Dhinesh

Was this reply helpful? Yes No
Verified answer

Therese Youssef Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dhinesh28R,

We can use IsBlank function along with SearchUser function to check if the user is a member of O365 or not.

IsBlank is a boolean function. It checks if a value is Blank, will return true.

So we can say:
If(!IsBlank(First(Office365Users.SearchUser({searchTerm:"user_that_exists"})).DisplayName), <add the action you want to do>)
This condition checks if user exists in the O365, then you can add any action you want.

For more information about IsBlank function, see: Blank, Coalesce, IsBlank, and IsEmpty functions - Power Apps | Microsoft Docs

If this answers your question, please mark your post as Solved.

Hope the above content may help you.
Thanks.

Was this reply helpful? Yes No