Get Error Message Instead of Success Message in Power Apps

Like (0) Share

Report

Posted on 17 Mar 2023 13:46:19 by Community Power Pla...

Hi All,

Urgent Help needed to Fix the below Error

I have created a Power App that picks the Excel Data as an attachment and updates the SQL Table by running a Stored Procedure through Power Automate Flow.

Everything works as expected, but even after the successful execution of the Flow and Data getting stored in SQL Table the Power Apps still throws me an Error.

Below is the Formula that I have created On-Select

ForAll(abcde,Patch(NC_stg,Defaults(NC_stg),{xxx:Value(ThisRecord.xxx);yyy:ThisRecord.yyy}));ExecuteStoredProcedure.Run(); Notify("The Data was Synced Successfully", NotificationType.Success); Notify("There was an Error while Synching the Data", NotificationType.Error)

Below is the Power Automate Flow running -

I am not able to fix the notification functionality. If Success, it should display a success message or else an error message.

Thanks

Categories:

General Questions

All responses (2)

Answers (0)

AJ_Z 3,711 Super User 2024 Season 1 on 01 Apr 2023 at 12:12:24

Like (0)

Report

Re: Get Error Message Instead of Success Message in Power Apps

Did this help resolve your issue?
AJ_Z 3,711 Super User 2024 Season 1 on 18 Mar 2023 at 20:57:58

Like (0)

Report

Re: Get Error Message Instead of Success Message in Power Apps

This Issue is In relation the response and the notify in the app.

end the flow with this instead of the response you are using.

Update the formula in the app to:
ForAll(abcde,Patch(NC_stg,Defaults(NC_stg),{xxx:Value(ThisRecord.xxx),yyy:ThisRecord.yyy}));Set(varFlowResponse,ExecuteStoredProcedure.Run()); If(varFlowResponse.isSuccess = true,Notify("The Data was Synced Successfully", NotificationType.Success), Notify("There was an Error while Synching the Data", NotificationType.Error))

In Blue is the bits I changed. Let me know how this goes and if you have any questions.

It looks like you may have duplicated this question but I have added the answer on both so you can see it.