I have list which contains 117 items , Now i want to loop through this list i expecting some thing like below.
For each item in list
Insert into DB.
I can insert the first date but not all
Go to 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.
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.