Associate records and auto update when a record already exists using Power Automate

Hello Everyone,

Today i am going to share use case scenario:

Create Operational cost records and associate with a project record when project is already created.

Solution: Power Automate Flow:

1. Manually trigger a flow.

2. List Projects

3. Apply to each.

Select an output from previous steps – outputs(‘List_Projects’)?[‘body/value’]

4. List Master Operational costs, select the Master Operational Costs (refer to above screenshot).

5. Apply to each 2: select an output from previous steps “value” outputs(‘List_Master_Operational_Costs’)?[‘body/value’]

Add a new row 2

Table name – Operational Costs

Name – Name ( formula: items(‘Apply_to_each_2’)?[‘acg_name’]

Project(projects) – msdyn_projects – items(‘Apply_to_each’)?[‘msdyn_projectid’]

Quantity – Quantity – items(‘Apply_to_each_2’)?[‘acg_quantity’]

Unit Cost = Unit Cost – items(‘Apply_to_each_2’)?[‘acg_unitcost’]

Finally when you run this flow “Operational Costs” records will be created for “Project” record.

I hope this helps.

Malla Reddy(@UK365GUY)

#365BlogPostsin365Days