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 |
| | | |
Line 22: |
Line 24: |
| === 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 |