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


Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!


Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!


Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!


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!


Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors
Users online (6,404)