Posts

Showing posts from October, 2025

Items in Power Automate

   Meaning of items() in Power Automate In Power Automate, items() is a function that represents the current item being processed inside a loop , such as an Apply to each action. Think of it like this 👇 If you have a list of rows and Power Automate loops through them one by one — items() refers to the single row currently being processed. 🧩 Example Suppose: Your “List rows” ( List_rows_1 ) returns: { "body" : { "value" : [ { "fullname" : "John Doe" , "emailaddress1" : "john@contoso.com" } , { "fullname" : "Jane Smith" , "emailaddress1" : "jane@contoso.com" } ] } } You then add an Apply to each action: Apply to each: value = outputs ( 'List_rows_1' )?[ 'body/value' ] Inside this loop: On the first iteration , items() = { "fullname" : "John Doe" , "emailaddress1" : ...

Power Automate Body/Value Expression

 In Power Automate , the expression output ('List_rows_1')? [ 'body/value' ] (or equivalently outputs('List_rows_1')?['body/value'] ) is used to extract the data rows returned by a "List rows" action from Dataverse , SharePoint , or another connector that returns a list of items. Let’s break it down 👇 🔍 Explanation of Each Part Part Meaning outputs('List_rows_1') Refers to the entire output (JSON) of the action named List_rows_1 . The action name can differ (e.g., List_rows , List_records , etc.) ? Safe navigation operator — prevents errors if that property doesn’t exist. ['body/value'] Accesses the array of records in the response body — i.e., all the rows returned by the List Rows action. 🧩 Example Suppose your List rows action ( List_rows_1 ) retrieves contact records from Dataverse. The raw output might look like this (simplified): { "body" : { "value" : [ { ...