List.Transform a dynamics set of columns with a value from a function call

Question

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 a table with all optionsets and a step where I join my columnnames to this table. So I know which columns contain an optionset value.

I have created a function which delivers the right label for the optionset value.

OptionLookup(opstionsetvalue, "entityname", "optionsetname(columnname)")

So basically I created a step:

Table.TransformColumns(DateToLocal,List.Transform(OptionsetColumns,

each { , each OptionLookup(, "bookableresource", "here should the columnName be as text"), type text}))

the _ provides the right current value needed for the function, the function is also applied to the right columns but the function needs the ColumnName in text and I don't know how to get this. I tried OptionsetColumns but then the whole list is inserted there.

Answer 1

@Bob Faessen

I believe your question is related to Microsoft Fabric. Please post on the dedicated forum and our experts there should be able to help.

https://community.fabric.microsoft.com/