Using Patch to SP list

(1) Share

Report

Posted on by BenGillard

120

I am curently using the following to add records to SP which works great.

Patch(PIOT,Defaults(PIOT),Form2.Updates,Form3.Updates,Form4.Updates,Form5.Updates)

Whats the best way for me to know it has posted succesfully to SP and get a pop up saying successful?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report

Good question. Unfortunately, the documention is thin on areas such as error handling. But perhaps try the following:

Patch('data source name', ...);If(Not(IsEmpty(Errors('data source name'))),Navigate(ErrorScreen,ScreenTransition.None),Navigate('Success Screen',ScreenTransition.None))

Of course, the above is navigating to different screens, replace the navigate with calls to the notify function to get a banner at the top of the current screen.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @BenGillard,

Do you want to check if the Patch formula executes successfully?

Based on the needs that you mentioned, I think the Errors function could achieve your needs. I have made a test on my side, please check the following workaround:

Set the OnSelect property of the "Patch" button to following formula:

If(
IsEmpty(Errors('20190108_MainList', Patch('20190108_MainList', Defaults('20190108_MainList'),{Title: "PowerApps"}))),
Notify("Patch Record Successfully!",NotificationType.Success),
Notify("Patch Record Failed!", NotificationType.Error)
)

On your side, you should type following:

If( IsEmpty(Errors(PIOT, Patch(PIOT, Defaults(PIOT), Form2.Updates, Form3.Updates, Form4.Updates, Form5.Updates))), Notify("Patch Record Successfully!", NotificationType.Success), Notify("Patch Record Failed!", NotificationType.Error) )

Please check the attached GIF screeshot for more details:

More details about Errors function, please check the following article:

Errors function

Best regards,

Test.gif

Was this reply helpful? Yes No