cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RussellGove
Level 10

The specified CSR Application encountered an error and the application has terminated

Hi,

Im trying to filer a sql Azure table based on a date column using this expression

 

Filter(
'[dbo].[vw_observationObservee]',(ObservationDate>=DateAdd(DatePickerObservationsFrom.SelectedDate,-30,Days))

)

 

Getting an error  saying  The specified CSR Application encountered an error and the application has terminated.\

 

Can anyone else confirm? Should this work?

2 REPLIES 2
Community Support Team
Community Support Team

Re: The specified CSR Application encountered an error and the application has terminated

Hi @RussellGove ,

Could you please share a bit more about the error message within your app?

Could you please show more details about the ObservationDate column in your Azure SQL table? Is it a datetime type column?

 

I have made a test on my side, and don't have the issue that you mentioned. Please consider take a try to re-create a new connection to your Azure SQL Table from your app, and then take a try with the following formula:

Filter(
       '[dbo].[vw_observationObservee]', 
Value(Text(ObservationDate, "[$-en-US]yyyymmdd")) >= Value(Text(DateAdd(DatePickerObservationsFrom.SelectedDate, -30, Days),"[$-en-US]yyyymmdd")) )

check if the issue is solved.

 

If the issue still exists, please consider take a try to re-create a new app based on your Azure SQL Table, then take a try with above formula I mentioned, check if the issue still exists.

 

If the issue still have not been fixed, please consider collect the Session ID value of your app, then submit an assisted support ticket with obtained Session ID through the following link:

https://powerapps.microsoft.com/en-us/support/pro/

 

More details about getting Session ID of a canvas app, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-sessionid

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TopShelf-MSFT
Level 10

Re: The specified CSR Application encountered an error and the application has terminated

Thanks for posting in the community @RussellGove - can you review the above reply and update the thread regarding this issue?

 

Thank you,

 

@TopShelf-MSFT 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,785)