Difference between revisions of "Dataverse Connector"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
== 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. <i>/contacts(guid)</i> for setting a lookup to a contact. | ||
| + | |||
| + | * [https://linnzawwin.blogspot.com/2019/11/power-automate-how-to-set-lookup-field.html HOW TO SET LOOKUP COLUMN VALUE IN MICROSOFT DATAVERSE CONNECTOR IN CLOUD FLOWS] by Linn Zaw Win | ||
| + | * [https://crmtipoftheday.com/1311/use-entity-name-in-flow-lookups Use entity name in flow lookups] by CRM Tip of the day | ||
=== List Rows === | === List Rows === | ||
| − | * After using List Rows, if you want to check if there was no rows returned, use this expression <i | + | * After using List Rows, 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. |
| − | * After using List Rows, if you want a value from the first item, use this expressions <i | + | * After using List Rows, if you want a value from the first item, use this expressions <i>first(body('List_rows')?['value'])?['name']</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 09:14, 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
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.
- HOW TO SET LOOKUP COLUMN VALUE IN MICROSOFT DATAVERSE CONNECTOR IN CLOUD FLOWS by Linn Zaw Win
- Use entity name in flow lookups by CRM Tip of the day
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.