cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAppsJunkie
Helper II
Helper II

How to verify a user is active in Office 365 via SP list?

Hello All,

 

I have a SharePoint list where I have "Username" and "Email Address".  I need to create a gallery that displays the list but it only displays Users from that list who still have an active office 365 account.  I'm then needing to have a function where I could prune the users from the SharePoint list that aren't active any longer in AD, so have say a "prune disabled accounts" button that would remove any users who are in the SP list that are no longer in AD/Office365users.

 

I've toyed around with showing a gallery and then checking the list vs if the account is active and returning a true / false to a label in the gallery but I'm not sure how I then can filter that gallery based on that because it said something about circular references which I know I'm doing something wrong but just not sure how to fix it.

 

Here is what I'm using to show users from the SP List in the gallery and then the label that shows them as accountEnabled "true / False"

Gallery statement:
Filter('SharePoint List', Office365Users.UserProfileV2('Email Address').accountEnabled)

This has an issue due to the amount of items in the list.  It gives me a warning about filtering so I would like to fix that.  It also only shows the accounts that are "true"

Is there a way to figure out which accounts are false?  If so then I would want to take the ones that are false and have a button that would remove all those items from the SP list.

Any ideas?







3 REPLIES 3
RezaDorrani
Dual Super User II
Dual Super User II

Hi @PowerAppsJunkie 

 

How about have a Flow that runs periodically and updates SharePoint list with account enabled (Yes or No)

 

The in PowerApps just have a simple filter 

Filter(SharePointList, AccountEnabled = "yes")

 

If flow is not a preferred option,

then in PowerApps you would to get all the data in a gallery and then hide gallery item (for each item) by using Office365Users.UserProfileV2('Email Address').accountEnabled as Visible property

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

I was actually just exploring the option to create a flow that would lookup the users and if they are active to write a column item and then just filter it with PowerApps but I'm not sure how to do that.

The syntax of putting things together is where I struggle right now because I'm pretty new to Coding and Powerapps syntax. So it's a ton of trial and error on my end.

So any idea on the flow I'd create to do the list update? @RezaDorrani 

Ok So it looks like I can do a flow like this:

Use a get items flow to grab the items from the SP list
Do a for each so it gathers all items from the list

Then I do a get user from Azure AD

and do a condition if the Azure AD get user = the SP list items email then 
Update item in SP list field to yes or no

I got that part working in a flow so now I'll start working on the Powershell view

I am wondering if there is anyway to do it as well because I like exploring all options

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (5,273)