Update/ Create Secondary Sharepoint list from Primary SharePoint Lis

(0) Share

Report

Posted on by straight1

Greetings.

I'm currently developing a flow in Power Automate, which runs as follow:

Order1 is primary list, Order2 is secondary list
New input will be captured in Order1 for each product ordered

Based on trigger, there will be revision in Order2 for every new input from Order1:

If the product has been ordered before (same product name as current list), it will update current line/ row in Order2
If the product is first-time ordered (new product), it will create a line/ row in Order2

Order1 is the individual product order.

Order2 is the cumulative product order.

Here's the layout for SharePoint Lists Order1 and Order2:-

What is the suitable walkthrough/ process flow to be created in Power Automate to

I have tried this approach before:

Trigger > Get Item > Condition > Update Item/ Create Item,

but now I'm stuck at merging/ combining two or more rows (which has same product name) in Order1 to single row in Order2.

(example as above: ItemA)

Kindly assist

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-liwei-msft on at

Like (0)

Report

Hi @straight1

The idea is as follows:
1. When a new item is added to Order1, filter whether there is the same item in Order2.

2. Use the condition to judge whether the length of the filter array is greater than 0. (It is greater than 0 to prove that there are identical items, and equal to 0 to prove that there are no identical items)

3. When it is greater than 0, traverse the result of the filter array (although there is only one identical item), and use get item to get the initial value of the same item.

4. Use update item to change the value.

5. When equal to 0, directly use the value returned by trigger to add a new item to Order2.
Test Outcome:

Best Regards,
Levi

Was this reply helpful? Yes No
straight1 6 on at

Like (0)

Report

Hi @v-liwei-msft
Thanks for the reply

Just curious, what is the command/ expression for ID column at Step 3?

I tried this, however there is a 'Apply to Each' added automatically at Step 1 - during Filter Array

How about columns with different format or contains lots of information?
Example: Person/ Group, Choice, Date/ Time

Was this reply helpful? Yes No
v-liwei-msft on at

Like (0)

Report

Hi @straight1

The ID field comes from Filter Array.

Best Regards,
Levi

Was this reply helpful? Yes No
straight1 6 on at

Like (0)

Report

Hi @v-liwei-msft

The solution is still not working.

Questions:
1. To sum up the several rows of the orders from the same product in Order1 to single row of aggregated sum of product in Order2
2. To update, not overwrite or create new line/ row in Order2 for products that have been registered
3. What is the expression of 'ID' column in Step 3 - not shown above
4. How do I know which columns is updated?
Thanks

Was this reply helpful? Yes No