Adding an Address Book

Login as Tenant Admin and go to Configuration (Admin)

1. Locate "Address Books" in the Configuration list.
2. Click on "Create New" → A dialog window will open
   1. Specify the Name and Icon
   2. Pick an Organization Unit (OU) to make this address book available under.💡 The higher the OU level, the more users will see the entries in their Attendant Console search. Keep data privacy in mind when playing the book.
   3. When editing a Specify the source for the table of contacts.
   4. Confirm when done.

Create Excel Sheet

1. Create an excel sheet with user details and make sure it is in a table format – see example below:
   
2. Save the excel sheet for your team to access, e.g. in the "Files" tab created for each Nimbus service team.
   💡 Of course you can vary this step by using any other SharePoint location accessible to you or any selection of team members / owners.
   ☝ Please note that by default "Files" in a team are accessible to all team members. Ensure not to expose any potential private customer data in your address book.
   

Create flow for the address book

✅ This step requires that you have previously configured Nimbus Power Automate Connector (Custom Connector) for your tenant. Otherwise the "Nimbus" action and selectable Trigger Events will not show show in your MS Flow-Search.

1. Log into your Microsoft Power Automate account https://emea.flow.microsoft.com/
2. Go to "My Flows" and click on "New Flow" > "Automated Cloud Workflow"
3. Click on "Skip" and search for the "Schedule" connector (Recurrence).
   💡 Select an interval of your own preference and make sure to select the correct time zone.
4. Add a new step called "List rows present in a table" from from the "Excel Online" connector.
   1. Select your service team location, document library, file, and table.
      💡 This is the Excel from the previous step. You can of course place the file somewhere else, but keep in mind that your Flow user needs permanent access to the file's storage location and no one else should have access to the file and personal details therein.
   2. If your Excel list (or whichever data source you've chosen instead) includes a lot of entries, you may find that Power Automate will by default only return the first 256 entries. To get more entries, you can access the Settings of the "List rows present in a table" action and enable the Pagination feature, with an appropriate page size.
5. Add a new step called "Apply to Each" from the in the "Control" connector.
   1. Select "Value" as an output and click on "Add an action."
   2. Within "Custom" search for or directly select "AddOrUpdateContact" in the "Nimbus" Connector.
   3. Check within "AddOrUpdateContact" that all fields are correctly mapped to the columns of your excel file.
6. Don't forget to name your flow and click on save
7. Verify that your flow now looks something like this:
   

Verify

1. Test that your flow runs successfully at least once without errors. 💡 1 You can of course also adjust or replace the initial "Recurrence" trigger to anything else that ensures that new entries to your Excel Address book entries are transferred over into Nimbus Address Books in a timely manner.
2. You can also validate via the search of Attendant Console if (new) entries are shown, with the Address Book icon shown as source. 
   

🌟 Congratulations - you have now successfully made address book management easier for your team.