Hi @Jcook ,
There are around 30 projects; In total there are 4000 deliveries, going from 1 delivery for a project, to 1400 deliveries for the largest project...
These are the licenses:
These are the actions:
"actions": {
"List_records": {
"runAfter": {},
"type": "OpenApiConnection",
"inputs": {
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
"connectionName": "shared_commondataserviceforapps",
"operationId": "ListRecords"
},
"parameters": {
"entityName": "pdc_projects",
"$filter": "statecode eq 0"
},
"authentication": "@parameters('$authentication')"
}
},
"Initialize_variable": {
"runAfter": {
"List_records": [
"Succeeded"
]
},
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "sumProduct",
"type": "float"
}
]
}
},
"Apply_to_each": {
"foreach": "@outputs('List_records')?['body/value']",
"actions": {
"Set_variable": {
"runAfter": {},
"type": "SetVariable",
"inputs": {
"name": "sumProduct",
"value": 0
}
},
"List_records_2": {
"runAfter": {
"Set_variable_2": [
"Succeeded"
]
},
"type": "OpenApiConnection",
"inputs": {
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
"connectionName": "shared_commondataserviceforapps",
"operationId": "ListRecords"
},
"parameters": {
"entityName": "pdc_productforprojects",
"$filter": "_pdc_project_value eq @{items('Apply_to_each')?['pdc_projectid']}"
},
"authentication": "@parameters('$authentication')"
}
},
"Apply_to_each_2": {
"foreach": "@outputs('List_records_2')?['body/value']",
"actions": {
"Increment_variable": {
"runAfter": {},
"type": "IncrementVariable",
"inputs": {
"name": "sumProduct",
"value": "@items('Apply_to_each_2')?['cr6ea_productkostprijs']"
}
},
"Increment_variable_2": {
"runAfter": {
"Increment_variable": [
"Succeeded"
]
},
"type": "IncrementVariable",
"inputs": {
"name": "sumLoon",
"value": "@items('Apply_to_each_2')?['cr6ea_loonkostprijs']"
}
}
},
"runAfter": {
"List_records_2": [
"Succeeded"
]
},
"type": "Foreach"
},
"Update_a_record": {
"runAfter": {
"Apply_to_each_2": [
"Succeeded"
]
},
"type": "OpenApiConnection",
"inputs": {
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
"connectionName": "shared_commondataserviceforapps",
"operationId": "UpdateRecord"
},
"parameters": {
"entityName": "pdc_projects",
"recordId": "@items('Apply_to_each')?['pdc_projectid']",
"item/cr6ea_kostprijsloon": "@variables('sumLoon')",
"item/cr6ea_kostprijsproducten": "@variables('sumProduct')"
},
"authentication": "@parameters('$authentication')"
}
},
"Set_variable_2": {
"runAfter": {
"Set_variable": [
"Succeeded"
]
},
"type": "SetVariable",
"inputs": {
"name": "sumLoon",
"value": 0
}
}
},
"runAfter": {
"Initialize_variable_2": [
"Succeeded"
]
},
"type": "Foreach",
"runtimeConfiguration": {
"concurrency": {
"repetitions": 1
}
}
},
"Initialize_variable_2": {
"runAfter": {
"Initialize_variable": [
"Succeeded"
]
},
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "sumLoon",
"type": "float"
}
]
}
}
}
