Hi All,
I am working on an app with Dataverse as a source. I am trying to use group by function to filter data and get the sum of values based on the grouped data. Please find the code below.
ClearCollect(colEffortRecSummary,GroupBy(Filter(GHRSREQM_EffortRecordingTables,MainRequestGUID=Text(gvarHRSRequestGUID)),mmi_party,mmi_application,mmi_role,groupeditems)); //Grouping by three columns called Party, Application and Role and groupeditems is the name of the groupeddata.
The above code works fine and satisfies my requirement.
I observed a weird thing that suddenly after each save of the application or after some time , the code just randomly gets modified to the below at the places in the app.
ClearCollect(colEffortRecSummary,GroupBy(Filter(GHRSREQM_EffortRecordingTables,MainRequestGUID=Text(gvarHRSRequestGUID)),Party,Application,Role,groupeditems));
There is no error being shown but this code does not bring out the groupedvalues and is not working as per my requirement. mmi_party become Party , mmi_role becomes Role, mmi_application becomes Application.
Please need your help with this code.
Thanks in advance.