With the SharePoint Birthdays app you can show current and upcoming birthdays of for example students or employees on your display.
Easily turn a simple SharePoint list into a good looking birthday list in Lumicast. The SharePoint list needs to have at least two columns: a name and a date.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2Fb002a8a0-0976-4380-81a4-e22d28dda19f%2FUntitled.png?table=block&id=6bf864d2-9451-4fe8-a10f-c3de56147bc3&cache=v2)
Creating a SharePoint Birthdays app
- Go to ‘Apps > App store’ or ‘Content > New > App’ and search for the SharePoint Birthdays app;
- Click on the app to start creating a new app. You will see the following screen:
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F2bff5edb-c6dc-4bd3-aa81-1f240d293d2a%2FUntitled.png?table=block&id=ff8a016c-249f-4215-8d57-b5d479f6cdde&cache=v2)
- Enter an app name, this can be anything you can recognize it by later;
- Setup an App Registration in Azure to let Lumicast access the SharePoint site. This is explained below.
- The Tenant ID and Client ID can be found on the overview page of the app registration.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2Fdb6c4674-3b64-4d18-aaa1-0849ffe859b9%2FUntitled.png?table=block&id=b979ea18-7675-45ba-b67f-a04f388afc7b&cache=v2)
- The site hostname is the unique name of your SharePoint environment. This can for example look like: lumicast.sharepoint.com
- The client secret is the value of the secret you created in step 4.
- If the details are correct, you should see your SharePoint lists in the “List name” dropdown field. Here you can select your birthdays list. It may take a few seconds for the list to load.
- In the Name and Date field, fill in the exact column names of the list.
- Finish the app by clicking ‘Create app’
Setting up an App Registration in Azure
- Go to the Azure portal on https://portal.azure.com.
- Go to the Microsoft Entra ID service.
- Under the “Manage” section, click on “App registrations”.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F1ff65000-9e12-4a31-a676-1cf4d5fd9f71%2FUntitled.png?table=block&id=b91b2073-a37c-457b-85d8-4a6eeffb3a91&cache=v2)
- Click on “New registration”. Give the registration a name, for example “Lumicast connection”. The other settings can be left as they are by default.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2Fe2145d3b-980f-4d4a-8548-edc952f4ddc6%2FUntitled.png?table=block&id=8f755c97-9238-473a-b40a-6fdea5ac16ff&cache=v2)
- After creating the app registration, it needs to have permissions to read the SharePoint data. Go to the API permissions tab to do this.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F7fb562aa-e426-403b-9bbc-7df2808fcee5%2FUntitled.png?table=block&id=4342b8dd-34b3-4df4-9f4a-fb2cb5f3da11&cache=v2)
- Click the “Add a permission” button and select “SharePoint”.
- Choose the “Application permissions” type.
- Select the “Sites.Read.All” permission and add this permission. This will allow Lumicast to only read the data from your SharePoint site.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F60439d70-3fc3-4df7-bd0c-00346dd2ae94%2FUntitled.png?table=block&id=f3228898-4869-411f-bf79-17b46ee1d69d&cache=v2)
- Add another permission and select “Microsoft Graph”.
- Choose the “Application permissions” type.
- Select the “Sites.Read.All” permission and add it.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F8c82b14d-6df0-4ea7-938a-b3956f551a43%2FUntitled.png?table=block&id=2aff4f29-e51c-4efc-8ef5-3fa2a7d32d49&cache=v2)
- In order to activate the permissions, click on the “Grant admin consent for …” button.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F84351484-3161-4a7e-9a4f-3e7ec72f62c9%2FUntitled.png?table=block&id=a435edeb-22bb-4433-9445-dec1da772290&cache=v2)
- Go to the “Certificates & secrets” tab to create a secret key for Lumicast to access the Site data with.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F07928af5-c413-4e8a-a371-dbd8a58431a0%2F91d90c99-4ef1-4f12-870a-616a48ac4279%2FUntitled.png?table=block&id=f9930851-087a-4181-b099-ea305da9c6d0&cache=v2)
- Click on “New client secret” and give it a name and an expiry data. Keep in mind that you will need to update the secret once it has expired.
- Store the secret in the “Value” field, because it will not be shown again.
Data update frequency
Lumicast checks your sharepoint data every minute. If you don’t see a new birthday that you just added, the reason could be that we have not picked it up yet. Please wait at least one minute.
All configuration options
Setting | Explanation | Required |
App name | A recognizable (descriptive) name for you, which will show in your content library. | Yes |
Tenant ID | The App Registration tenant ID, found on the overview page of your App Registration. | Yes |
Site hostname | The hostname of your SharePoint site. This could for example look like lumicast.sharepoint.com | Yes |
Client ID | The App Registration Client ID, found on the overview page of your App Registration. | Yes |
Client Secret | The value of the secret within your App Registration. | Yes |
SharePoint Site | The site that contains the list you want to use. | Yes |
List name | The SharePoint list that contains birthday data. | Yes |
Name field | The column name of the field that should be displayed as name. | Yes |
Date field | The column name of the field that should be used for the birthdate. | Yes |
Language | The language of the month names. | Yes |
Days to show in advance | Specified how many days in advance should a birthday be displayed on the display. | Yes |
Color when it’s someone’s birthday | The background color of the row when a birthday is today. | Yes |
Color when it’s not someone’s birthday | The background color of the row when a birthday is not today. | Yes |
Color of the text | The color of the text within the rows. | Yes |
Text to show when it’s someone’s birthday | The text to display in the row when it is someone’s birthday. | Yes |
Text to show when there is no upcoming birthday | If there are no birthdays in the lookahead window, this text is shown. | Yes |
Font | Font family to use. | No |
Background image | Specify a custom image to be displayed behind the birthday rows. | No |
Hide background image | Completely hide the background image. Useful when for example using this app in a page. | No |