web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps run patch and then hav...

Power Apps

Answered

run patch and then have textbox show that last id

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a screen, not a form. textbox1, button to execute the patch.

I need a textbox1 to show the last id created specifically to a user.

The user field is called User1. That value is from txtUser.Text on the screen.

The Patch code: I'm running this patch code.

Patch('[dbo].[t_redbook_pricing_escalation_master]',Defaults('[dbo].[t_redbook_pricing_escalation_master]'),
{
QS_RACFID: txt_QS_RACFID.Text,
STATUS: "Pending Leader Review",
ESCALATION_CREATED_BY: txt_qs_fullname.Text,
DATE_ESCALATION_CREATED: Now()

}
)
;

Thanks

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Please consider changing your Formula to the following:

Set(PatchResult, Patch('[dbo].[t_redbook_pricing_escalation_master]', Defaults('[dbo].[t_redbook_pricing_escalation_master]'), { QS_RACFID: txt_QS_RACFID.Text, STATUS: "Pending Leader Review", ESCALATION_CREATED_BY: txt_qs_fullname.Text, DATE_ESCALATION_CREATED: Now() } ) )

Set the Label Text property to : PatchResult.ID

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation