Forum Discussion
mrc_bob
3 years agoRegular Visitor
List.Transform list of columns with return value with function which needs the actual columnName
I am trying for a while to have a dynamic step to transform the data from 1-n columns with the result of a function call. We are working on Dynamics 365 where we have a lot of optionsets. I have...
miguel
Community Admin
3 years agoHey!
Is there any way that you can share a functional example M code that contains that list and what you're trying to achieve? wondering how your list actually looks like
mrc_bob
3 years agoRegular Visitor
I have one step with Table.ColumnNames which contains f.e. 3 columnsNames resourcetype, msdyn_startlocation,usertype.
This step is called OptionsetColumns and used in the List.Transform.
the each _ gives the value of the column f.e.669010000.
which I need as well the provide as the 1st parameter to the function but need the columns name like resourcetype as well.
I will post some more details later. Now on my phone....