Unanswered

Creating an item using dynamic fields from multiple lists

(0) Share

Report

Posted on by MicrosoftUser1

I am trying to create an item on a new (List 3) when items are modified from another list (List 1). The fields in the new list (List 3) will need to contain fields from 2 different lists (one where the item is modified (List 1) and the other which contains other relevant background information (List 2)).

I have been able to create item using just List 1. However List 3 contains fields needed from List 2 so these are currently blank as I am currently stuck on getting the items from List 2 and consolidating it into the new list (List 3) with the created item. Does anyone have any advice?!

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @MicrosoftUser1

Could you search for the item in List 2 based on a specific field? You could do something like this:

1) Get items from list2 based on title from list1

2) Get the first item you get from previous step.

Using the expression:

first(outputs('Get_items-List2')?['body/value'])

You would get the desired item from List 2.

Hope it helps!
Ferran

Was this reply helpful? Yes No
MicrosoftUser1 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Ferran, thanks for your quick reply!

Unfortunately the above did not work. So I would need to get mutliple fields. There are 5 columns in List 1 and 4 columns in List 2 to be consolidated into List 3, when a specific column in List 1 is modified from "no" to "yes". Do you have any advice for this?

Thanks,
Shaliza

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

The point is... Which is the relation between List 1 and List 2 ? How do you find related records? By Title column? By any other column?

Regards,

Ferran

Was this reply helpful? Yes No