Difference between revisions of "Dataverse Connector"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
=== List Rows === | === List Rows === | ||
| − | * After using List Rows, if you want to check if there was no rows returned, use this expression <i><b>empty(body(' | + | * After using List Rows, if you want to check if there was no rows returned, use this expression <i><b>empty(body('List_rows')?['value'])</b></i> in a condition. If that is equal to true - means no rows returned. |
| + | * After using List Rows, if you want a value from the first item, use this expressions <i><b>first(body('List_rows')?['value'])?['name']</b></i> to look for attribute name. | ||
== Community Resources == | == Community Resources == | ||
* [https://onlinemgblog.wordpress.com/2021/06/05/building-flow-2-dataverse-get-optionset-label/ Building Flow #2: DataVerse: Get Optionset Label] | * [https://onlinemgblog.wordpress.com/2021/06/05/building-flow-2-dataverse-get-optionset-label/ Building Flow #2: DataVerse: Get Optionset Label] | ||
Revision as of 08:58, 15 December 2021
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
List Rows
- After using List Rows, 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.
- After using List Rows, if you want a value from the first item, use this expressions first(body('List_rows')?['value'])?['name'] to look for attribute name.