Power Platform Community Forum Thread Details

Hello!! This is my first time posting on a forum so forgive me if I'm not familiar with the practices! But I've run into this awful issue with an app I made and am seeking any help I can get!

I work in the Training Department for my company and made two applications to assist with the requesting of various training classes from our department. I'm not a professional coder so please don't be too harsh if my code isn't great!

The first is an app that Managers can utilize to request training for their employees, the second is an app called 'Enrollment Manager' that the Instructors can use to see which employees need which training classes so they can plan their training schedules to accommodate.

The issue I'm having is with the Enrollment Manager Power App. Up to this point it has worked without any issues, but upon adding a new class to a Choice table in Dataverse called 'Class Requesting' and removing an old class we no longer offer, now the Enrollment Manager app is giving this error upon start up saying "Invalid data from the network", and will not display any Dataverse data in the gallery I've made to display it.

The weird thing is: the data from the Dataverse table 'Training Requests' is showing just fine in the 'Manager's' application where they can request training, though the Gallery there is much more simplified. It's just in the 'Enrollment Manager' app I've made that I'm having issues.

I haven't made any published updates to the app since May 2024 and it's been working fine until I made that small change to the Class Requesting choice table just yesterday. I even tried to change it back to the original info but that didn't seem to help. Do you think some of the functions I'm using have been deprecated or something since May 2024?

Here is the code that is showing an error in my Gallery on the Enrollment Manager application. Any help would be much appreciated, thank you so much!

If(lockMode, Filter(
With({scope:
Sort(
    Filter(
        Filter(
            'Training Requests',
            And(('Class Requesting' in ClassSelectionComboBox.SelectedItems || ClassSelectionComboBox.Selected.Value = Blank()),
        (Instructor in InstructorFilterComboBox.Selected.Value || InstructorFilterComboBox.Selected.Name = Blank()),
        ('Enrollment Status' in EnrollmentStatusComboSelect.SelectedItems || EnrollmentStatusComboSelect.Selected.Value = Blank()),
        (TextInput2.Text in 'Manager Name' || TextInput2.Text = Blank()), (Text(ClassStartDateFilter.SelectedDate) in 'Class Start Date' || ClassStartDateFilter.SelectedDate = Blank()),
        If(Radio2.Selected.ID = 1, 'Inactive Request' = "false", Radio2.Selected.ID = 2, 'Inactive Request' = "true", Radio2.Selected.ID = 3, "true" || "false"))),
        
        (StartsWith(Text('Enrollment Status'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Manager Name'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Class Requesting'), txt_SearchBox.Text)) ||
        (StartsWith(Text(Instructor), txt_SearchBox.Text)) ||
        (StartsWith(Text('Org Code'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Preferred Start Time'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Employee Name'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Employee Number'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Submission Time'), txt_SearchBox.Text)) ||
        (txt_SearchBox.Text = Blank())
        ),
    
    'Submission Date', 
    SortOrder.Ascending
)
},
ForAll(Sequence(CountRows(scope)) As Seq,
Patch(Last(FirstN(scope, Seq.Value)),
{RowNumber: Seq.Value}))),
(StartsWith(Text('Enrollment Status'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Manager Name'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Class Requesting'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text(Instructor), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Org Code'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Preferred Start Time'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Employee Name'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Employee Number'), txt_lockedSearchBox.Text)) ||
        (StartsWith(Text('Submission Time'), txt_lockedSearchBox.Text)) ||
        (txt_lockedSearchBox.Text = Blank())
        ), 
With({scope:
Sort(
    Filter(
        Filter(
            'Training Requests',
            And(('Class Requesting' in ClassSelectionComboBox.SelectedItems || ClassSelectionComboBox.Selected.Value = Blank()),
        (Instructor in InstructorFilterComboBox.Selected.Value || InstructorFilterComboBox.Selected.Name = Blank()),
        ('Enrollment Status' in EnrollmentStatusComboSelect.SelectedItems || EnrollmentStatusComboSelect.Selected.Value = Blank()),
        (TextInput2.Text in 'Manager Name' || TextInput2.Text = Blank()), (Text(ClassStartDateFilter.SelectedDate) in 'Class Start Date' || ClassStartDateFilter.SelectedDate = Blank()),
        If(Radio2.Selected.ID = 1, 'Inactive Request' = "false", Radio2.Selected.ID = 2, 'Inactive Request' = "true", Radio2.Selected.ID = 3, "true" || "false"))),
        
        (StartsWith(Text('Enrollment Status'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Manager Name'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Class Requesting'), txt_SearchBox.Text)) ||
        (StartsWith(Text(Instructor), txt_SearchBox.Text)) ||
        (StartsWith(Text('Org Code'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Preferred Start Time'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Employee Name'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Employee Number'), txt_SearchBox.Text)) ||
        (StartsWith(Text('Submission Time'), txt_SearchBox.Text)) ||
        (txt_SearchBox.Text = Blank())
        ),
    
    'Submission Date', 
    SortOrder.Ascending
)
},
ForAll(Sequence(CountRows(scope)) As Seq,
Patch(Last(FirstN(scope, Seq.Value)),
{RowNumber: Seq.Value})))
)