Unanswered

Employee Birthday

(1) Share

Report

Posted on by send2mark

505

Is there a way to use standard connectors to query all employees for birthdays? I then want to put them into a SharePoint list to be displayed on the current date.

I saw something about using MS Graph, but I think that will require a premium connector, right?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

poweractivate

11,078 Most Valuable Professional on at

Like (0)

Report

Copy link

Link copied!

@send2mark

I believe Office 365 Connector for Power Automate might actually not be Premium, so you may be able to use without access to Premium connectors.

You can try using Office 365 Actions from Flow such as Search for Users and Get User Profile Action from a Flow and see if it works for you.

Get user profile (V2)

Operation ID:: UserProfile_V2

Retrieves the profile of a specific user. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties

Parameters

Name	Key	Required	Type	Description
User (UPN)	id	True	string	User principal name or email id
Select fields	$select		string	Comma separated list of fields to select. Example: surname, department, jobTitle

Then you can just query the birthday field by selecting from Dynamic content, Birthday under "Select fields".

From Available fields:

birthday

DateTimeOffset

The birthday of the user. The Timestamp type represents date and time information using ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z.

Returned only on $select.

Presuming all of the above works, you can potentially use Search Users, then use Apply to Each, then inside Apply to Each, use Get User Profile. Then you can also place this information (birthday) in the SharePoint list from either inside Apply to Each, (or outside Apply to Each after appending to an Array or String variable initialized at the top of the Flow), depending on scenario.

Was this reply helpful? Yes No

New-AzGuru 179 on at

Like (0)

Report
Copy link

Link copied!

Hey, I know this is an older post, but can you provide a code snippet of exactly how the expression should be to pull the birthday (or any other value that's returned only on $select) ?

Was this reply helpful? Yes No