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!

I have the same question (0)

All responses (3)

Answers (0)

fchopo 8,001 Moderator on at

Like (0)

Report
Re: Creating an item using dynamic fields from multiple lists

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

Re: Creating an item using dynamic fields from multiple lists

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,001 Moderator on at

Like (0)

Report

Re: Creating an item using dynamic fields from multiple lists

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