Hi Mona,
I think this may be related to another issue I posted with the DataTable,
I just changed the Filter from a dynamic value , variable rStatus is set based on user selection, to a hard coded value:
rStatus can equal one the following: Pending, Approved, or Rejected
Silently Fails:
Filter('SPList', Status = rStatus)
Each of the following Fail with the WebAuthoring abnormal termination:
Filter('SPList', Status = "Pending" )
SessionID: fc957e35-2f51-cc44-4c7c-0e12fabea2c1
Filter('SPList', Status = "Approved" )
SessionID: 7512df7e-f93a-f517-4515-7e9c2cc4beb2
Now when get to this point, the DataTable shows nothing even though I change the Status to either of the above or back to the variable rStatus. This is a new session due to the WebAuthoring abnormal termination.
Filter('SPList', Status = "Rejected" )
SessionID: No Session ID given, and it never Filters.
Also I published this version and launched it into Dynamics365, this now shows the Red Error bar that the O365OfficeUsers.Manager and O365OfficeUsers.MyProfile are throwing errors?, this does not happen in development mode.
But now the DataTable will Filter once and ignore other calls to Filter.
Thank you for looking into this.