3,312
edits
Changes
no edit summary
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
=== List Rows ===
=== 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.
== Community Resources ==
* 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.
* [https://onlinemgblog.wordpress.com/2021/06/05/building-flow-2-dataverse-get-optionset-label/ Building Flow #2: DataVerse: Get Optionset Label]
* 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('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
Remember to use your own name of the step instead of 'List_rows'.
=== 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
== See also ==
* [https://crmtipoftheday.com/pages/power-automate-gymnastics-reference-guide/ Power Automate Gymnastics Reference Guide] by CRM tip of the Day
* [https://danikahil.com/2022/04/power-automate-dataverse-cheatsheet.html Power Automate – Dataverse Cheatsheet] by Dani Kahil