Forum Discussion

JackSoderstrom's avatar
JackSoderstrom
Helper I
4 years ago

Return a null Custom Connector Navigation Table Item

let ColumnNames = Table.ColumnNames(DatabaseRecords(num)), Tabled_Column_Data = ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{1})), objects = #tabl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JackSoderstrom 

I think you can try Table.RowCount function in your M query. If count not blank row equal to 0, then return null.

Here I find a offical blog about Handling Navigation, I hope it could help you solve your problem.

For reference: Handling Navigation

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.