Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Flow access to SP user profiles & properties

Does somebody know whether it's possible to access data from the following list from within Flow ? Which method & what to search for(URL, SP object,...) ?

Purpose > while accessing the list we can determine who's new in the organisation and let Flow automatically send a personalised  'Welcome' HTML mail.

In addition would it also be possible to update custom profile fields using Flow?

Community Support Team
Community Support Team

Re: Flow access to SP user profiles & properties

Hi @EricDeferm,


Could you provide more explanation about your needs?

Do you want to know how to access the URL you provide through Flow or monitor who is accessing a particular list?

Also if you want to get the details of a member of an organization, you could try Get user profile action.

Through this action, you could get the corresponding user's email, and configure the obtained email in Send an email action.

And configure the HTML code in the Body, select Yes in the Is html field to send the welcome message.


Best Regards,


Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Flow access to SP user profiles & properties

Tx @v-bacao-msft for your prompt reply. What do we want to achieve?  Our main objective is to send a welcome message to new hires by checking the creation of new accounts in Azure AD (if they get a mail box) or Office 365 user account. Currently we have a manual process in place in the sense that we've created a Power BI dashboard that shows the new hires on a weekly basis. From Power BI we export a CSV file, which is then used in combination with a Word document to start a Mailing for sending a personalised email to the new hire using Outlook Desktop App. We want to replace this manual process with an automated process. I've figured out how to send a personalised HTML mail using MS Flow, but encounter difficulties to determine or retrieve a list of new hires on a weekly/daily basis by accessing Office 365 user list or Azure AD. Any method to retrieve a list of new users within MS Flow would do the things for us. Tx.

Level: Powered On

Re: Flow access to SP user profiles & properties

I admit that the timing of my question (just before Xmas holidays) could be better. Hence a short reminder in the hope that someone has a bright idea/alternative way/method to achieve what we're looking for. I'm happy to investigate several options when having a good starting point. No clue yet which approach would best fit our goals, could be:

- schedule Powershell command to retrieve list of new hires on daily basis and send HTML mail

- MS Flow retrieving data from AD or O365 user list

- anything else?

Tx & brgds.

Helpful resources


New Ranks and Rank Icons in April

Read the announcement for more information!


Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,833)