Forum Discussion
Importing sometimes empty XML table - Expression.Error: There weren't enough elements
Hello - I am building a storm tracker and I want to elegantly handle when there is no XML data tables because the query returns an empty result. At the moment it throws an error: Expression.Erro...
Hi, Surfacescan
The reason for the error message is that a column name you were referring to wasn't in the particular xml file you were using. I'd like to suggest you use Table.Isempty() function to check if the table is empty. If it is not empty, then you can refer to the column in the table and do some transformations. Or you can refer to Error Handling to troubleshoot the error.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.