Add content to SharePoint list item from two different arrays

(0) Share

Report

Posted on by cbernier12

248

Hi,

I'm attempting to add content to SharePoint list items from two different arrays, however when I select from each array Flow nests the apply each twice and I get dupes of everything. Anyone know how to add data from two different arrays and then update an array of list items without creating dupes?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @cbernier12

The only option in this case is declare a variable and select the type accordingly. Then iterate the second loop outside the other loop (Before the create item step) and set the value. Later you can use the variable under the create item.

Note: I don't know your exact logic is so if you thinking to create a single item using both arrays then iterate both arrays as separate get all values and assign to correct variables. So in this case you may needed more than one variable for creating the item.

Thanks

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I did try the variable route, however it always nests the variable in a apply each and then won't save because nesting variables isn't supported. Any way to stop the variable from nesting automatically?

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report
Copy link

Link copied!

This is the error I receive: The inputs of workflow run action 'Set_variable' of type 'SetVariable' are not valid. Self reference is not supported when updating the value of variable 'varDisplayName'.

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

Hi @cbernier12
Try to provide some screenshots, which would expedite the process.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @cbernier12

If you getting self referencing error means you have the following scenario.

You have variable A = "Test A" and another variable B = "Test B" then you want to combine both variable to "Test A Test B" and store to variable A. That means variable A = Variable A + Variable B. But in Power Automate this is not possible. What you need to do is declare another variable C and do the following

Variable C = Variable A + Variable B

Hope it make sense.

Thanks

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report
Copy link

Link copied!

How would I do Variable C = Variable A + Variable B on two separate arrays without the action turning into apply each?

Was this reply helpful? Yes No