We are trying to build a searchable phone list on our sharepoint intranet. One of the possible way is to implement it with the list function. Would like to know if it is possible to make the list be able to update automatically (ie, when there is a new employee), instead of updating it manually, since MS list have access to all employee's Active Directory account.
How to build a searchable phone list on MS sharepoint that can be updated automatically with our MS ad account?
CG
Dear Solomon,
If you have PowerApps, the easiest way is to use PowerApps to create a gallery showing the users with their phones. You can refresh the connector Office 365 Users by a button such as setting the text input control value as a variable value var and typing the formula UpdateContext({var:"u"});UpdateContext({var:""}) on the Refresh the phone list to refresh the galley.
Type the formula Search(Office365Users.SearchUser(),TextInput1.Text,DisplayName) on the gallery.
You can then embed the app on the SharePoint site page with the PowerApps web part.
Use the Power Apps web part - Microsoft Support
Another way is to use the Graph API connector in a flow to update the SharePoint Online list automatically. You need to buy the Power Automate premium license and create a more difficult flow to move forward.
Even though you need to buy the PowerApps license when using the solution as well, I think that it is much easier to be done.
Thank you for your time and effort.
Sincerely
Cliff | Microsoft Community Moderator
Question Info
Last updated April 15, 2025 Views 391 Applies to: