I’m running a query which returns a record with a number of fields.
If the record contains the field ‘CashField’, the query continues as normal. However, if the field does NOT exist, is there a way to terminate the query cleanly and exit the function i.e. not subsequent steps from running?
let
Source = Excel.CurrentWorkbook(){[Name="CASH_FLOW_QUERY"]}[Content],
...
res = Record.HasFields(Source, "CashField"),
in
res
Attempted if statements and error handling but no success
New contributor
Bella Grubb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.