Hi,
I am slowly trying to build my first function. I am starting without the parameters and will add them later.
I have the below code and basically i want to run the add column for each column provided in the SplitList (two rows in this case).
let
Source = OData.Feed("https://XXXX.crm.dynamics.com/api/data/v9.1/contacts?$select=contactid,statecode,statuscode", null, [Implementation="2.0", IncludeAnnotations="OData.Community.Display.V1.FormattedValue"]),
SplitList = Text.Split("statuscode,statecode",","),
#"Converted to Table" = Table.FromList(SplitList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Added Custom" = Table.AddColumn(Source, "statuscode_meta", each Value.Metadata( each Text.From(#"Converted to Table"))[OData.Community.Display.V1.FormattedValue]?)
in
#"Added Custom"
Now if i change the custom col to this it works. So how do i feel the list of columns into this? Also how do i change the custom so that it is also changing per Splitlist (pref with _Name added at the end).
#"Added Custom" = Table.AddColumn(Source, "Custom", each Value.Metadata([statuscode])[OData.Community.Display.V1.FormattedValue]?)
Many thanks
Dan
