Patch conditional columns

(2) Share

Report

Posted on by ctpmthh

If(
    CountRows(colErrors) = 0,
    With(
        {
            patchRecord:
                Patch(
                    {
                        // ✅ ALWAYS FIELDS
                        ProcessedBy: vObj.flowProcesState.ProcessedByApp,
                        FlowProcessState: vObj.flowProcesState.ToProcess
                   
                        
                       
                    },
                    // ✅ 1st Approver
                    
                    If(
                        CountRows(Filter(varChangedOnly, Column="FirstApproverDecision")) > 0,
                        {
                            FirstApproverDecision: var1stDecision,
                            DecisionDate1App: Now()
                        },
                        {}
                    ),  
 
  Set(tpatch,patchRecord);
 
 IfError(
            Set(
                vRecordViewWEdit,
                Patch(
                    SPlist,
                    LookUp(SPlist, ID = vRecordViewWEdit.ID),
                    patchRecord
                )
            );
            
Patch is working, but when i want to debug i cant see this conditional columns in variable why? allways i see only
ProcessedBy: And FlowProcessState: even if contion is true for FirstApproverDecision  but patch is patching correctly when condition is true... how im able to see this conditional column??
"Thank you for every piece of advice."!!
        

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

11manish 3,347 on at

Like
a
(0)

Report
Copy link

Link copied!

Since the SharePoint Patch succeeds, your logic is correct. The issue is only with the debugger's visualization of dynamically merged records.

For debugging, I recommend:

Set(varPatchJson, JSON(patchRecord, JSONFormat.IndentFour))

This is the easiest and most reliable way to inspect the exact contents of patchRecord, including all conditional fields.

Was this reply helpful? Yes No
Suggested answer

Valantis 6,778 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ctpmthh,

To actually see the conditional fields, capture the Patch result itself:

Set(debugResult, Patch(SPlist, LookUp(...), patchRecord, If(condition, {...}, {})))

Then JSON(debugResult) will show everything that was written, including the conditional columns. debugResult comes back as the full updated SharePoint record.

Best regards,

Valantis ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/ 💼 LinkedIn ▶️ YouTube

Was this reply helpful? Yes No