3,312
edits
Changes
no edit summary
== 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><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 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><b>first(body('List_rows')?['value'])?['name']</b></i> to look for attribute name.
* 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]