This App run into a problem (MS Error Message)

(0) Share

Report

Posted on by KI-13090739-0

Hi there,

I am struggling with Error that has been discussed here already. But each story seems to be individually.

It always happens when I fetch data from a SharePoint list and show them in a gallery. I use filter controls to get data into a collection. I already tried previous version of PowerApps in the settings. No solution.

When I switch to the browser's developer mode is can identify the event. But details do not give me an idea in PowerApps.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,779 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sharing (in Text) your Gallery Items code and any Collection code here would be highly useful to try to help you.

Was this reply helpful? Yes No
KI-13090739-0 12 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz,

here is my coding for selecting items

Set(SpinnerShow, true);

Refresh(MyFieldService);

ClearCollect(Col_FieldServices,

Sort(Filter(MyFieldService,

(

(T_Supervisor.Checked

And

(

Technician_Lead.Email = F_LTechnician.Selected.Mail

Or

IsBlank(F_LTechnician.Selected.DisplayName)

)

)

Or

(Technician_Lead.Email = My_User.mail)

)

And

(Service_closed = CB_SReport_closed.Checked Or CB_SReport_closed.Checked = false )

//And

//((ServiceReport > 0 And CB_SReport.Checked) Or CB_SReport.Checked = false )

And

(Customer = F_Customer.Selected.Value Or IsBlank(F_Customer.Selected.Value))

And

(EquipmentNo = F_EquipNo.Selected.Value Or IsBlank(F_EquipNo.Selected.Value))

And

(to <= DP_Max.SelectedDate Or IsBlank(DP_Max.SelectedDate))

And

(from >= DP_Min.SelectedDate Or IsBlank(DP_Min.SelectedDate))

And

((SAP_Managed = true) Or CB_SAP.Checked = false )

), from, SortOrder.Descending));

Set(SpinnerShow, false)

Was this reply helpful? Yes No
WarrenBelz 153,779 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @KI-13090739-0

I am not sure this is the issue (I have never see that error before) but some suggestions, particularly the highlighted one.
UpdateContext({SpinnerShow: true}); //Refresh(MyFieldService); ClearCollect( Col_FieldServices, Sort( Filter( MyFieldService, ( ( T_Supervisor.Checked And ( Technician_Lead.Email = F_LTechnician.Selected.Mail Or Len(F_LTechnician.Selected.DisplayName) = 0 ) ) Or Technician_Lead.Email = My_User.mail ) And ( ( Service_closed And CB_SReport_closed.Checked ) Or !CB_SReport_closed.Checked ) And ( Customer = F_Customer.Selected.Value Or Len(F_Customer.Selected.Value) = 0 ) And ( EquipmentNo = F_EquipNo.Selected.Value Or Len(F_EquipNo.Selected.Value) = 0 ) And ( to <= DP_Max.SelectedDate Or Len(DP_Max.SelectedDate) = 0 ) And ( from >= DP_Min.SelectedDate Or Len(DP_Min.SelectedDate) = 0 ) And ( SAP_Managed Or !CB_SAP.Checked ) ), from, SortOrder.Descending ) ); UpdateContext({SpinnerShow: false});

I also assume the following field types

Technician_Lead - Person

Service_closed, SAP_Managed - Boolean (Yes/No)

Customer, EquipmentNo - Text

to, from - Date

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
KI-13090739-0 12 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

I excluded already filter conditions. But this does not help.

I think no one can help here. I will create a ticket at Microsoft.

Was this reply helpful? Yes No
KI-13090739-0 12 on at

Like (0)

Report
Copy link

Link copied!

I will have a call from MS or Third-Party soon.

It is also strange that only conditions that lead to a an empty result will cause this problem. I will update later.

Was this reply helpful? Yes No