Changes

* 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 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 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.

 

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