Create Table Storage in Azure

1. Log into the Azure portal.
2. Create a Table - you can follow the instructions on Quickstart - Create an Azure Storage table in the Azure portal | Microsoft Docs.
   🔍 By default rowKey is a string. It is important that your rowKey holds the phone number, because this column is indexed and thus efficient to search.
3. Next, insert some example data for testing purpose. You can use the Storage browser → Tables → (your table name) → Add entity
   🔍 Note, that the phone number holds the complete string with country prefix, in the same format as Microsoft Caller ID holds it in our Power AutomateConnector.

Once the table is created and has at least one entry to query on, you can use it inside your Power Automate flow.

Create the flow

1. Visit the Flow landing page: https://make.powerautomate.com/
2. Go to "My Flows".
3. Click "+ New Flow" and create a blank "Automated Cloud Flow".
4. Give your new flow a speaking name, e.g., "Get Caller Name".
5. In the text box underneath, search for “Nimbus” and choose the “When a task changes state” trigger.
6. Click the Create button.
   
7. Select the “When a task changes state” trigger.
8. In the “Services Item” dropdown select the Nimbus service's UPN.
   💡 You can also get the data of multiple services at this point, but for the sake of simplicity we keep it to one service in this example.
9.  In the “Task Events” dropdown select “System Accepted”.
10. In the “Advanced parameters” dropdown enable “Modalities” and "Directions".
11. In the “Modalities Item” dropdown select “Audio”.
12. In the “Directions Item” dropdown select “Inbound”.
13. In the editing area click to add a new action.
14. Search for "Azure table storage get entity" and select “Get entity (V2)” under the “Azure Table Storage” section.
15. Configure the action as follows:

Field	Value to fill in / 🌟 = Nimbus dynamic content
Partition Key	Enter the value you used for PartitionKey in your Azure Table (In our example this is byCallerId)
Row Key	🌟Microsoft Caller ID
Storage Account Name Or Table Endpoint	Enter the name of the storage account
Table	Enter the name of the Table containing the data

💡 In case no connection exists yet for the Azure Table Storage, Power Automate will ask you first to connect. To get more information about the options, please have a look at the Azure Table Storage - Connectors article. 

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

1. Search for "Nimbus" and select “Update task” under the “Luware Nimbus” section.
2. Configure the action as follows:

Field	Value to fill in / 🌟 = Nimbus dynamic content
Task ID	🌟 Task ID
Customer First Name	outputs('Get_entity_(V2)')?['body/additionalProperties/Firstname']
Customer Last Name	outputs('Get_entity_(V2)')?['body/additionalProperties/Lastname']
Customer Display Name	outputs('Get_entity_(V2)')?['body/additionalProperties/Firstname'] outputs('Get_entity_(V2)')?['body/additionalProperties/Lastname']

Fill the Azure Table with Excel Data

Now that everything works, we just need to fill the Excel data into the Azure Storage Table.

You can easily upload a csv using the Microsoft Azure Storage Explorer (Download at http://storageexplorer.com/). Or you write a script for PowerShell. Here is the code snippet for adding a new row:

$cloudTable = 'crm'
$callerNumber = '+44786536774'
$item = @{Firstname="Mathias"; Lastname="Meier"; Company= "Big Dreams"; PreferedCoulour= "Red"}
Add-AzTableRow -table $cloudTable -PartitionKey 'byCallerId' -rowKey $callerNumber -proper