fill in a SharePoint list according to an Excel file and other SharePoint lists for search columns

(1) Share

Report

Posted on by Hii_iii

691

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?

Categories:

Business Process Flows

Flow Mobile App

All responses (3)

Answers (0)

Hii_iii 691 on at

Like (1)

Report

fill in a SharePoint list according to an Excel file and other SharePoint lists for search columns

.
QWales 40 on at

Like (1)

Report

fill in a SharePoint list according to an Excel file and other SharePoint lists for search columns

I'll start by saying I'm no expert and it is difficult to see what's going on with all your crossing out but..

If you can't view the output data, try sending yourself a Post Message in Chat or Channel Teams message and put a bunch of the output fields\columns in that so you can see what's going on.

Another thought is that you could try changing your variable to text

Are you using Parse JSON, I can see everything in my table when I look at the sysout of that?

Mine looks like this:
Hii_iii 691 on at

Like (1)

Report

fill in a SharePoint list according to an Excel file and other SharePoint lists for search columns

:'(