cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TamilselviK
Helper I
Helper I

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

TamilselviK_0-1628237409909.png

 

 

For each item in list

Insert into DB.

 

I can insert the first date but not all

 

Regards,

Tamilselvi K

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors