Unanswered

Not able to store values through Apply to Each Loop

(0) Share

Report

Posted on by linkgtaylor

Friends, I have tried several tutorials but none have fully worked. I want my work flow to do the following:

Whenever someone updates the Status (field) of the Projects Pipeline list, I want to log this in another list called Status Change with info on the status changed from, status changed to, date of previous status change, current date of change. I am open to suggested. Below is just one of the approaches I took. It seems the "Apply to each" loop which is recording updates for the Status and Modified field is creating two entries instead of one.

I tried this:

The updated list result was (highlighted in red below. One entry is desired is, not two. The status field should not have date time info.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

lbendlin 8,626 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What is the source for the first "Apply to each" ?

Was this reply helpful? Yes No
linkgtaylor 6 on at

Like (0)

Report
Copy link

Link copied!

Apply to Each:

{

"type": "Foreach",

"foreach": "@body('Select')",

"actions": {

"Compose_Field_Name": {

"type": "Compose",

"inputs": "@items('Apply_to_each')"

},

"Compose_New_Item": {

"type": "Compose",

"inputs": "@triggerOutputs()?['body']?[item()]",

"runAfter": {

"Compose_Old_Status": [

"Succeeded"

]

}

},

"Create_item_in_Status_History": {

"type": "OpenApiConnection",

"inputs": {

"parameters": {

"dataset": "https://mof1.sharepoint.com/sites/SubmissionsManagement",

"table": "3b12410c-dd4a-4300-a8b1-898e5f14aa24",

"item/Title": "@triggerBody()?['Title']",

"item/StatusChangedFrom/Value": "@outputs('Compose_Old_Status')",

"item/StatusChangedTo/Value": "@outputs('Compose_New2')",

"item/ProjectID/Id": "@triggerBody()?['ID']"

},

"host": {

"apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",

"connection": "shared_sharepointonline",

"operationId": "PostItem"

}

},

"runAfter": {

"Compose_New2": [

"Succeeded"

]

}

},

"Compose_Old_Status": {

"type": "Compose",

"inputs": "@outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?[item()]",

"runAfter": {

"Compose_Field_Name": [

"Succeeded"

]

}

},

"Compose_New2": {

"type": "Compose",

"inputs": "@contains(string(triggerOutputs()?['body']), item())",

"runAfter": {

"Compose_New_Item": [

"Succeeded"

]

}

}

},

"runAfter": {

"Send_an_HTTP_request_to_SharePoint": [

"Succeeded"

]

}

}

Was this reply helpful? Yes No
linkgtaylor 6 on at

Like (0)

Report
Copy link

Link copied!

The first "Apply to each" outputs the Status and the second the Modified date

Was this reply helpful? Yes No
Mark Nanneman 991 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you show your "Select" action's mapping?

Was this reply helpful? Yes No
linkgtaylor 6 on at

Like (0)

Report
Copy link

Link copied!

{

"type": "Select",

"inputs": {

"from": "@body('Filter_array')",

"select": "@json(item())"

},

"runAfter": {

"Filter_array": [

"Succeeded"

]

}

}

Was this reply helpful? Yes No