How to loop through a list using Power Query

[Anonymous]

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

[lbendlin · Accepted solution]

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.