Answered

When ‘Choice’ item is modified in Sharepoint List, add new value to 2nd Sharepoint List

(0) Share

Report

Posted on by WallacD_31

Thought I had this done, but obviously doing something wrong as although the flow is processing, the fields of the 2nd List are not being updated.

When user selects an option from a 'Choice' column in a Sharepoint List, I want to add that new value to a field in another Sharepoint List. The individual record line in each list has the same Unique ID for matching.

Expression: length(body('Filter_array'))

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @WallacD_31 ,

I have made a simple test for your reference.

1. Here are my lists.

2. Here is my Flow.

[ { "Value": Dynamic Content } ]
length(outputs('Get_items')?['body/value'])
{ "Value": @{items('Apply_to_each_2')?['Value']} }
union(variables('VarArray2'),variables('VarArray1'))

Result Screenshot:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
WallacD_31 10 on at

Like (0)

Report
Copy link

Link copied!

Many thanks Charlie. I think I understand this. Will give it a go tomorrow and let you know how I get on 🙂

Was this reply helpful? Yes No
WallacD_31 10 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately (and this is a reflection on my knowledge) I'm struggling to prevent the first array from being swallowed into an 'Apply to each'. Is there a way I can do this?

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WallacD_31 ,

Maybe you could check the source(Trigger/Action) of the dynamic content.

Best Regards,

Charlie Choi

Was this reply helpful? Yes No