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 th...
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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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.