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 |
| | | |
| === List Rows === | | === List Rows === |
− | * 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 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. |
− | * 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. | + | |
| + | * 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. |
| + | * 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 === | | === 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 | | * [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 |