Dataverse Connector - Revision history

CarinaMClaesson at 19:59, 5 April 2022

2022-04-05T19:59:11Z

2022-02-09T14:05:55Z

2022-02-08T12:31:53Z

2022-02-08T12:31:23Z

2022-02-08T12:30:39Z

2022-02-08T12:29:31Z

2022-02-08T12:29:01Z

2022-02-08T12:20:53Z

2021-12-20T11:25:17Z

2021-12-15T09:14:48Z

← Older revision		Revision as of 19:59, 5 April 2022
Line 27:		Line 27:
	== See also ==		== See also ==
	* [https://crmtipoftheday.com/pages/power-automate-gymnastics-reference-guide/ Power Automate Gymnastics Reference Guide] by CRM tip of the Day		* [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

← Older revision		Revision as of 14:05, 9 February 2022
Line 24:		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

@@ 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.
 * [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
@@ 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.
 * [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 15: / Line 15: @@
 * 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.
 Remember to use your own name of the step instead of 'List_rows'.

@@ Line 14: / Line 14: @@
 * 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('Get_Contacts')?['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.
 === 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

@@ Line 10: / Line 10: @@
 === 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 expression <i>first(body('List_rows')?['value'])?['name']</i> to look for attribute name.
 === 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

@@ Line 2: / Line 2: @@
 == Tips and tricks ==
 === 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 ==
 * [https://onlinemgblog.wordpress.com/2021/06/05/building-flow-2-dataverse-get-optionset-label/ Building Flow #2: DataVerse: Get Optionset Label]