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

Show upcoming birthdays on SharePoint page

Hi,

 

i don't know how to begin but powerapps seems a legitable start. I'd like to show upcoming birthdays on our SharePoint page using the input from Delve (user's birthday).

 

I'd like to put this on our SharePoint homepage, like some kind of upcoming event. When users don't entered their birthday their birthday won't be shown in the list.

 

Is this possible using powerapps? Or is there any other way to achieve this? 

 

Thanks in advance!

 

Henk.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Show upcoming birthdays on SharePoint page

Try the Graph Explorer again and, after you sign into it, go to the Query box at the top and put in the following:

   https://graph.microsoft.com/v1.0/me?$select=displayName,birthday

That will show you the birthday field (as well as your display name).  You can also use the select portion of the url query to select other fields in the profile.  Here you will find (under the User object definition) a list of all of the properties you can query.

 

Here is a good article on making a Graph API custom connector for PowerApps.

And here is one for a connector for Flow.

 

Now, back to your situation.  PowerApps is not really the answer for what you want as much as getting data out of Microsoft Graph and into a datasource that you can display on a SharePoint page is.  

Although there are multiple ways to go - I would suggest a simple one of creating a scheduled flow that gets a list of all users and then queries each user to gather the birthday information and store it in a SharePoint list.  Then using a view on the list, you can filter it to upcoming birthdays.

 

I'm a little anxious now to try this myself as it appears fairly straight forward.  Not for the faint of heart (when adding a custom connector and understanding that process), but definitely possible.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

7 REPLIES 7
Super User
Super User

Re: Show upcoming birthdays on SharePoint page

I don't believe that PowerApps is your best choice for this.


We do something every similar for an upcoming Birthdays (and also Work Anniversaries)

What we did was to create a list in SharePoint with the information needed.

Then just created a View with the logic to filter upcoming events (next 2 weeks worth in our case) in a list that we put on the main page.

The downside is, we have a few manual steps in the process.  One is that we need to update the view every year to filter properly.  The next is that all the entries in the list are manually entered.

 

Now granted, this was put together years and years ago.  If we have to revisit it, I would probably create a Flow to automatically add the list entries and possibly even to update the year (our view uses a field to get the proper year)

 

So...yes, you can certainly do something like this.  PowerApps...probably not the choice if you want it to just be there on the page.  Flow, good choice for managing the data that feeds your list though.

 

Hope this helps give you some ideas.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
henkprins
Level: Powered On

Re: Show upcoming birthdays on SharePoint page

Hello Randy,

 

thanks for your respond. 

 

I hoped it was possible to import the birthdays from Delve, perhaps into a SharePoint list. But as far as i know and googled this is not possible.

 

Manually enter the data is not an option as we have about 600 employees. 

 

So, again, thank you very much for your respond and time but i'm afraid your solution does not fit for our organisation.

 

Best regards, henk.

Super User
Super User

Re: Show upcoming birthdays on SharePoint page

Yes, my solution worked well for small organizations and also for those that had a "list" already of this information (it was easy to just import it all into a SharePoint list).


But, as far as Delve, the issue is - Delve is not a DataSource.  Delve pulls data through Microsoft Graph and other sources.

So, you would have to do that work on your own.

 

AND...of the life of me, I cannot find where the birthday is REALLY stored.  It's not seeming to be part of the AD record. I do see it in SharePoint profiles, but it doesn't seem consistent.  So, really the Graph API is the best source for it, but that involves a Custom Connector at this time.

 

The graph API allows you to pull that property. 

    https://graph.microsoft.com/v1.0/me?$select=displayName,birthday

 

You can go to the Graph Explorer and sign in and try that directly...you will see the birthday.

So, you could create a connector and then use Flow (or other resources) to grab the data for everyone in your organization.

 

Hope that gives more fuel for thought.  If you think you want to go the custom connector to the REST API. There are some good articles on it out there to be found (although not for the faint of heart). 

 

In fact, I'm now itching to change the way we did it years ago...I hate separate lists of the same data.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Community Support Team
Community Support Team

Re: Show upcoming birthdays on SharePoint page

Hi @henkprins,

Do you want to show upcoming birthdats within your Delve on your SP Page using PowerApps?

The Delve connector is not supported within PowerApps currently, if you want to show upcoming birthdats within your Delve on your SP Page using PowerApps, I afraid that there is no way to achieve your needs.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

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

Re: Show upcoming birthdays on SharePoint page

I know a little of microsoft flow. Powerapps isn't yet my cup of tea and until today i haven't heard of microsoft graph. 

 

For example: i tried microsoft graph, using the 'my profile' query, but cannot find the birthday entry.

 

I'd like to learn how to make connectors in flow and get info from Delve to show the birthdays on our page for i think this opens a lot of oppurtinities for other solutions, but i need a step-by-step tutorial to acclompish this. 

 

Not sure where to start. Any suggestions are more than welcome.

 

{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users/$entity",
"businessPhones": [
"xxxxxxxxxxxxxxxx"
],
"displayName": "Henk Prins",
"givenName": "Henk",
"jobTitle": "xxxxx",
"mail": "h.prins@xxxxxxxx",
"mobilePhone": null,
"officeLocation": null,
"preferredLanguage": null,
"surname": "Prins",
"userPrincipalName": "h.prins@xxxxxx",
"id": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
}

Super User
Super User

Re: Show upcoming birthdays on SharePoint page

Try the Graph Explorer again and, after you sign into it, go to the Query box at the top and put in the following:

   https://graph.microsoft.com/v1.0/me?$select=displayName,birthday

That will show you the birthday field (as well as your display name).  You can also use the select portion of the url query to select other fields in the profile.  Here you will find (under the User object definition) a list of all of the properties you can query.

 

Here is a good article on making a Graph API custom connector for PowerApps.

And here is one for a connector for Flow.

 

Now, back to your situation.  PowerApps is not really the answer for what you want as much as getting data out of Microsoft Graph and into a datasource that you can display on a SharePoint page is.  

Although there are multiple ways to go - I would suggest a simple one of creating a scheduled flow that gets a list of all users and then queries each user to gather the birthday information and store it in a SharePoint list.  Then using a view on the list, you can filter it to upcoming birthdays.

 

I'm a little anxious now to try this myself as it appears fairly straight forward.  Not for the faint of heart (when adding a custom connector and understanding that process), but definitely possible.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

henkprins
Level: Powered On

Re: Show upcoming birthdays on SharePoint page

Thnx, guess this will take some time for me to figure this all out. But you gave me some ideas to start. Thanks for that. Hope, in case i will get stuck, i can get back at you for some more support.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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