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. 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

1. Visit the Flow landing page: https://make.powerautomate.com/ 
2. Head to "My Flows"
3. Click on "+ New Flow" and create a blank "Scheduled cloud flow"
4. Give your new flow a speaking name, e.g. "Updating Nimbus Address Book", set the desired schedule 
5. Click the Create button

6. In the editing area click to add a new action

1. Search for "excel list" and select “List rows present in a table” under the “Excel Online (Business)” section
2. Configure the SharePoint Item as follows (💡 In this step you need the Excel file 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.):

Field	Value to fill in / 🌟 = Nimbus dynamic content
Location	Select the SharePoint Site hosting the Excel file from the dropdown box
Document Library	Select the document library storing the Excel file from the dropdown box
File	Select your Excel file from the dropdown box
Table	Select the table from your Excel file from the dropdown box

💡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.

9. In the editing area click to add a new action

1. Search for "Nimbus" and select “Update a contact in an address book” under the “Luware Nimbus” section
2. Configure action as follows:

Field	Value to fill in / 🌟 = Excel dynamic content
Addressbook	Select the Nimbus Address Book you created from the dropdown box
Contact External ID	🌟ID
Contact First Name	🌟Name
Contact Last Name	🌟Name
Contact Display Name	🌟Name
Contact Company	🌟Company
Contact Department	🌟Department
Contact Job Title	🌟Job Title
Contact Email Addresses	🌟E-Mail

12. 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.