Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to loop through a list using Power Query

Hi,

 

I have list which contains 117 items , Now i want to loop through this list i expecting some thing like below.

 

List

 

 

For each item in list

Insert into DB.

 

I can insert the first date but not all

 

Regards,

Tamilselvi K

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Add a custom column.  Specify the NativeQuery for the value.  Hit ok - Power Query will do the rest for you (apply each etc)

     

    BEWARE:  There are lots of issues with query caching.  It is not guaranteed that all your inserts will land, or that you won't have duplicate inserts.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Add a custom column.  Specify the NativeQuery for the value.  Hit ok - Power Query will do the rest for you (apply each etc)

     

    BEWARE:  There are lots of issues with query caching.  It is not guaranteed that all your inserts will land, or that you won't have duplicate inserts.