Show upcoming birthdays on SharePoint page

[henkprins]

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.

[RandyHayes]

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.

[henkprins]

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.

[RandyHayes]

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.

[v-xida-msft]

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,

[henkprins]

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"
}

[RandyHayes · Accepted solution]

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.

[henkprins]

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.