trigger Power Automate with Airtable

[Terilyn_Floyd-C]

The piece I am really struggling with is the comma delimited split. This is the order as done in power query.
Select entire tab/Table
Source = Excel.CurrentWorkbook(){[Name=“Table1”]}[Content],
#“Changed Type” = Table.TransformColumnTypes(Source,{{Many Columns/Fields}}),

Select only the Columns/Fields
#“Removed Other Columns” = Table.SelectColumns(#“Changed Type”,{“Key”, “ManyLinked”}),

Remove empty cells/rows
#“Filtered Rows” = Table.SelectRows(#“Removed Other Columns”, each ([ManyLinked] <> null)),

Split the ManyLinked into one row for each comma delimitate value - each row gets the value from Key and a single value from ManyLinked
#“Split Column by Delimiter” = Table.ExpandListColumn(Table.TransformColumns(Table.TransformColumnTypes(#“Filtered Rows”, {{“ManyLinked”, type text}}, “en-US”), {{“ManyLinked”, Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), “ManyLinked”),

Thanks, Teri

[Terilyn_Floyd-C · Accepted solution]

I found a solution that works in the published scripts. “Create record from multiple select”