Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

This App run into a problem (MS Error Message)

Posted on 1 Dec 2024 11:41:16 by 1
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:
  • WarrenBelz Profile Picture
    WarrenBelz 143,202 on 01 Dec 2024 at 20:43:18
    This App run into a problem (MS Error Message)
    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
  • KI-13090739-0 Profile Picture
    KI-13090739-0 1 on 01 Dec 2024 at 12:15:42
    This App run into a problem (MS Error Message)
     
    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)
  • WarrenBelz Profile Picture
    WarrenBelz 143,202 on 01 Dec 2024 at 12:01:08
    This App run into a problem (MS Error Message)
    Sharing (in Text) your Gallery Items code and any Collection code here would be highly useful to try to help you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,202

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,877

Leaderboard