Changes

no edit summary
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 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 hit for instance.
+
* 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.
    
=== 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