Changes

341 bytes added ,  12:29, 8 February 2022
no edit summary
Line 10: Line 10:     
=== 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 expression <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('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.
    
=== 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