Difference between revisions of "Dataverse Connector"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
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. | 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. | ||
| + | ==== Community Content ==== | ||
* [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://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 | * [https://crmtipoftheday.com/1311/use-entity-name-in-flow-lookups Use entity name in flow lookups] by CRM Tip of the day | ||
| Line 16: | Line 17: | ||
* If you want to know the number of rows retrieved, use this expression <i>length(body('List_rows')?['value'])</i> To be used e.g. in a condition if you want to verify that you got exactly one row back for instance. | * If you want to know the number of rows retrieved, use this expression <i>length(body('List_rows')?['value'])</i> To be used e.g. in a condition if you want to verify that you got exactly one row back for instance. | ||
| + | ==== Community Content ==== | ||
* [https://d365demystified.com/2020/05/20/get-count-of-records-retrieved-in-cds-connector-in-a-flow-power-automate/ Get Count of records retrieved in CDS connector in a Flow | Power Automate] by Priyesh Wagh | * [https://d365demystified.com/2020/05/20/get-count-of-records-retrieved-in-cds-connector-in-a-flow-power-automate/ Get Count of records retrieved in CDS connector in a Flow | Power Automate] by Priyesh Wagh | ||
Revision as of 12:31, 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.
Community Content
- 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 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('List_rows')?['value']) To be used e.g. in a condition if you want to verify that you got exactly one row back for instance.
Community Content
Remember to use your own name of the step instead of 'List_rows'.
Get labels of Choices
- Building Flow #2: DataVerse: Get Optionset Label by Mira Ghaly