Referencing one Sharepoint list in another with Power Automate

JUAN CAMILO GUTIERREZ 0 Reputation points
2023-02-20T17:08:16.83+00:00

Hello

I hope you can help me out. Recently I edited a Power Automate Flow that had a function to call data from one Sharepoint List to Another.

The main Sharepoint List is the next one (A List):

Imagen 1

And the secondary Sharepoint List is the next one (B List):

Imagen 2

the function was write in the underlined space of this item.

User's image

The function filled the "Subproceso ID" space with "Proceso" elements from B List depending on what number of ID was selected in a MS form. In addition to that, the A List add 2 Columns which are "Correo1" and "Correo2".

It is important to mention that this flow of create Item is modifying A List, and as you can see, when you select the A List it does not have the Columns "Correo1" and "Correo2" to modify manually those spaces.

I would like to know if there is any way to get to a function that allows you to make a reference between sharepoint lists and bring elements from one to another.

Thank you,

Best regards

Microsoft 365 and Office SharePoint For business Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.