Power Platform Community Forum Thread Details

Hello all,

This is what I am trying to do.

I have two list in sharepoint - Products and Items list:

As you can see, in the Items list, 'Product' column is a LOOKUP to the other first list 'Product' column.

I would like to create a power automate that adds the 'Item' from Item list to 'Item code' in the Products list.

We need to take into account that we can add more than one product in the column 'Product' . Also important, user can modify or delete a row in the items list that will have to update or delete in the Products list.

Another requirement is that, I would like to have the link of the item in the Products list 'Item code' , exactely the same as is shown in Items list 'Product' column.

I have started with the implementation in power automate but not success yet.

Do you think you could help me to figure out this ?

The result should be something like this, but Item Code should be a link to each item from the other list.