Difference between revisions of "Dataverse Connector"

From Power Wiki
Jump to navigation Jump to search
Line 14: Line 14:
 
* If you want to check if there was no rows returned, use this expression <i>empty(body('List_rows')?['value'])</i> in a condition. If that is equal to true - means no rows returned.
 
* If you want to check if there was no rows returned, use this expression <i>empty(body('List_rows')?['value'])</i> in a condition. If that is equal to true - means no rows returned.
 
* If you want a value from the first item, use this expression <i>first(body('List_rows')?['value'])?['name']</i> to look for attribute name.
 
* If you want a value from the first item, use this expression <i>first(body('List_rows')?['value'])?['name']</i> to look for attribute name.
* If you want to know the number of rows retrieved, use this expression <i>length(body('Get_Contacts')?['value'])<i/> To be used e.g. in a condition if you want to verify that you got exactly one hit for instance.
+
* If you want to know the number of rows retrieved, use this expression <i>length(body('Get_Contacts')?['value'])</i> To be used e.g. in a condition if you want to verify that you got exactly one row back for instance.
  
 
=== Get labels of Choices ===
 
=== Get labels of Choices ===
 
* [https://onlinemgblog.wordpress.com/2021/06/05/building-flow-2-dataverse-get-optionset-label/ Building Flow #2: DataVerse: Get Optionset Label] by Mira Ghaly
 
* [https://onlinemgblog.wordpress.com/2021/06/05/building-flow-2-dataverse-get-optionset-label/ Building Flow #2: DataVerse: Get Optionset Label] by Mira Ghaly

Revision as of 12:29, 8 February 2022

The Dataverse Connector is used in Power Automate cloud flows to connect to your Dataverse data. This page gathers tips and tricks.

Tips and tricks

Set lookup value

You cannot simply use the guid to set a lookup, you need to add also the entity name in front of it, e.g. /contacts(guid) for setting a lookup to a contact.

List Rows

After using List Rows you might want to verify the result, here are a few examples which might be handy. To be used e.g. a Condition Step or in a Compose or Variable step.

  • If you want to check if there was no rows returned, use this expression empty(body('List_rows')?['value']) in a condition. If that is equal to true - means no rows returned.
  • If you want a value from the first item, use this expression first(body('List_rows')?['value'])?['name'] to look for attribute name.
  • If you want to know the number of rows retrieved, use this expression length(body('Get_Contacts')?['value']) To be used e.g. in a condition if you want to verify that you got exactly one row back for instance.

Get labels of Choices