Forum Discussion
How to Refer to Tables and Table Name Variables in Custom Functions
I'm struggling with referencing Tables (as type table) and Tablenames (as type text) in a Custom Function. I have the following (part of a function) where the bolden items need to refer to the Table ...
Ive tried the last simple script a few times now, but using the GUI, so two step as follows:
= Table.SelectRows(Record.ToTable(#sections[Section1]), each [Name] = "SQLServerData")[Value]
= Source{0}
And when I click on APPLY, I still get the error "....(first) column does not exist in the rowset.."
The error always seems to refer to the first column in the dataset, no matter if the dataset is an excel worksheet or a table from SQL Server.