Power Platform Community Forum Thread Details

In a canvas app, I have a patch function which is repeating 5 times in different screen.

Patch('dbo.mytable',LookUp('dbo.mytable',ID=varID),
Switch(varTestID,
"A",{col1:varCurrentStatus},
"B",{col2:varCurrentStatus},
"C",{col3:varCurrentStatus},
"D",{col4:varCurrentStatus},
"E",{col5:varCurrentStatus}
)
);

Recently, we added a new column to dbo.mytable. So we need to update it with a new line:

"F",{col6:varCurrentStatus}

But we only updated one screen only. It introduced bug to the App.

I wonder is there any way I can create a reusable Patch function so that I can update one single place?

Categories:

Power Apps Pro Dev & ISV

Hey,

For something like this have you considered using a button (Button1) and adding your patch code to that? Yprou can then set Visible on the button to No and then anytime you want to run the patch function instead you write Select(Button1) that will then run your patch function.

For example on a hidden screen you have a Button1 with onSelect property set to:

Patch('dbo.mytable',LookUp('dbo.mytable',ID=varID),
Switch(varTestID,
"A",{col1:varCurrentStatus},
"B",{col2:varCurrentStatus},
"C",{col3:varCurrentStatus},
"D",{col4:varCurrentStatus},
"E",{col5:varCurrentStatus},

"F",{col6:varCurrentStatus}
)
);

Then anytime you want to execute that code on another screen you just run Select(Button1).

Hope that helps!

Asad