Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
@RICHARDCHIANG1 your Source does not look like a record... Anyway, _after in_ instead of res write smth like
if Record.HasFields(your_test_record, "CashField") then name_of_the_last_step else [Ted_Striker_Says = "what a pisser"]. Power Query M is "lazy" so it starts from the end and won't execute subsequent steps if this field is missing.
@RICHARDCHIANG1 your Source does not look like a record... Anyway, _after in_ instead of res write smth like
if Record.HasFields(your_test_record, "CashField") then name_of_the_last_step else [Ted_Striker_Says = "what a pisser"]. Power Query M is "lazy" so it starts from the end and won't execute subsequent steps if this field is missing.
I see, thank you! Before, i was trying something like: if Record.HasFields(your_test_record, "CashField") = False then <EXIT_QUERY> inside the LET statement... Sounds like my understanding of Power Query M was wrong!
@RICHARDCHIANG1 order of lines of your code does not matter
let
res = if b = 2 then null else c,
a = 1,
c = a + b,
b = 2
in
res