Unanswered

Why should records in an If formula have the same fields?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Can you guess what the JSON string value of ctxJson will be?

UpdateContext(
 {
 ctxJson: JSON(
 If(
 true,
 {
 onBothRecords: "First record",
 onlyOnFirstRecord: "onlyOnFirstRecord"
 },
 {
 onBothRecords: "Second record",
 onlyOnSecondRecord: "onlyOnSecondRecord"
 }
 )
 )
 }
);

SPOILER:

The answer is:

{"onBothRecords":"First record"}

So it seems that only the fields from the first record that are available on both records will be returned, otherwise the "onlyOnFirstRecord" field would have been serialized too.

Can somebody post some link(s) to an article or docs where this problem/feature is described? Is this a known issue?

PS. I attached an example Power App, so you can see this code in action.

RECORDS_ISSUE.msapp

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

alaabitar 1,503 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,
So I don't know why this is behaving like this but you could do something like
UpdateContext( { ctxJson: JSON( If( true, { onBothRecords: "First record", onlyOnFirstRecord: "onlyOnFirstRecord", onlyOnSecondRecord:Blank() }, { onBothRecords: "Second record", onlyOnSecondRecord: "onlyOnSecondRecord", onlyOnFirstRecord:Blank() } ) ) } );
And you will get
{"onBothRecords":"First record","onlyOnFirstRecord":"onlyOnFirstRecord","onlyOnSecondRecord":null}
in the ctxJson variable. At least with the null values you can know from witch json type the variable was filled.

Best regards,
Alaa
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @alaabitar , I figured that one out for myself. In my use case I didn't want to add Blank() values, because I was updating a database table and I wanted to only update certain columns based on the if condition. So to get that to work, I need to do something like the following:
If( myBooleanCondition, UpdateContext( { ctxJson: JSON( { onBothRecords: "First record", onlyOnFirstRecord: "onlyOnFirstRecord" } ) } ), UpdateContext( { ctxJson: JSON( { onBothRecords: "Second record", onlyOnSecondRecord: "onlyOnSecondRecord" } ) } ) )
But back to my original question, is this behaviour documented somewhere? Or is it a known issue? Please provide some links.