Hello ! I create a power automate workflow to fill in a SharePoint list according to an Excel file and other SharePoint lists for search columns.
I initially initialize my variable :
Then, in an "Apply to each" loop I define a "Compose" by giving it a value from the 19th column of a CSV file :
Then, I use the SharePoint component "get the elements" to obtain all the elements of the "sites" list if "Title" is equal to the output of "Compose" :
Then, I define my variable by giving it the value of the ID of each elements of the Sites list. :
Finally, I create elements in another SharePoint list and I add the variable.
But all the elements created in this SharePoint list have empty "sites" research column, I don't understand why. Can you help me please?
