Forum Discussion
Custom columns in a SharePoint Page Library
Either do them both in the same step or else change the reference to the prior step. Your new step is referencing the step before the first remove nulls step.
Here's both in the same step:
let Source = SharePoint.Tables("https:URL_GOES_HERE", [Implementation="2.0", ViewMode="All"]), #"793529eb-48c3-4fad-a005-7a4aa0a716ad" = Source{[Id="793529eb-48c3-4fad-a005-7a4aa0a716ad"]}[Items], #"Removed Other Columns" = Table.SelectColumns(#"793529eb-48c3-4fad-a005-7a4aa0a716ad",{"Name", "Author Byline"}), #"Fix Non List Values" = Table.TransformColumns( #"Removed Other Columns", {{"Author Byline", each if Value.Is(_, type list) then _ else null}, {"Checked Out To", each if Value.Is(_, type list) then _ else null}} ) in #"Fix Non List Values"
Thank you so much AlexisOlson 🙂
One final question, I actually have two columns of [List] data that both contain spaces. I've tried to add a second entry in the Applied Steps and just update the column name field, but it results in the 'null' entries 'jumping' from one column to the other:
I suspect it's because the hex long string in the applied steps isn't unique, do you know how I might fix that so I can have null entries in both columns, rather than just one or the other?
Apologies for 'teasing out' the requirements here, I really appreciate your time.
Either do them both in the same step or else change the reference to the prior step. Your new step is referencing the step before the first remove nulls step.
Here's both in the same step:
let
Source = SharePoint.Tables("https:URL_GOES_HERE", [Implementation="2.0", ViewMode="All"]),
#"793529eb-48c3-4fad-a005-7a4aa0a716ad" = Source{[Id="793529eb-48c3-4fad-a005-7a4aa0a716ad"]}[Items],
#"Removed Other Columns" = Table.SelectColumns(#"793529eb-48c3-4fad-a005-7a4aa0a716ad",{"Name", "Author Byline"}),
#"Fix Non List Values" = Table.TransformColumns( #"Removed Other Columns", {{"Author Byline", each if Value.Is(_, type list) then _ else null}, {"Checked Out To", each if Value.Is(_, type list) then _ else null}} )
in
#"Fix Non List Values"Fabulous AlexisOlson , thank you so much 🙂 That's exactly what I need.