cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EricDeferm
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  https://domain.sharepoint.com/_vti_bin/listdata.svc ? 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?

3 REPLIES 3
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,

Barry

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.
EricDeferm
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.

EricDeferm
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

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,847)