Melinda Cozza - Power Platform and CMS Developer

I have a column that I grouped by tracking number. I want to display how many items in the shipments went to each student. 
I had a column that had the shipped dates so when I grouped by tracking date, I got duplicate dates I didn't need.

***Note: I changed my date field to a text column in another step. I was doing something else with the data, like using power automate to write the outputs to a CSV and I didn't want to deal with the whole "Format Date and Time" in Power automate.             ++

Here's the cheat FX:

Cheater code:

Displays all the items in the status color is Blue or Yellow if nothing is in the search box,

The it will drill down by the name when the user enters name but only the items that are status "Blue" or "Yellow"

Then it sorts the gallery by the Title.

In the Visible Property:

If(ThisItem.ChoiceColumnName.Value = "-" Or ThisItem.ChoiceColumnName.Value = "No", false, true)

This code takes a Sharepoint list containing over 4000 items and allows the app user to search the list by legal name (Title) or PreferredName.
It sorts ascending and will show most of the sharepoint list items when the gallery is first loaded or if the app users resets the search text box.

However, it will search/filter the entire sharepoint list.

Reference: Blue= Null Field

In the text Property for the field:

Coalesce(ThisItem.NewLocation.Value, ThisItem.CeremonyLocation.Value)

Explanation:

If "ThisItem.NewLocation.Value" is Null or Blank then it will display this field> "ThisItem.CeremonyLocation.Value"

Add the SharePoint List field to your edit form and put this in it's DEFAULT property.

Coalesce(

 ThisItem.UpdatedBy,

 User().FullName

)

Then set the Visible property to: false

I need the filter to filter the datasource by status color and show me all records by default but only of the the Yellow color.

If (

    //This is for all and all

    DDLocations.Selected.Value = "All" And DDTimes.Selected.Value = "All", Filter('2025SummerGradCeremony',StatusColor.Value = "Yellow"),

    //This is for all locations and selected times

    DDLocations.Selected.Value = "All" And DDTimes.Selected.Value <> "All",

Run you flow once with the List rows action and look at the outputs. Should look like the below if you are in an environment.
Table_diplomaorderedrcvd@OData.Community.Display.V1.FormattedValue":"No","Table_diplomaorderedrcvd":false,"Table_diplomapending@OData.Community.Display.V1.FormattedValue":"-","

Change background color of Item base on values and conditions:

Gallery Property: TemplateFill

The DAX:
If(ThisItem.'U_STU_AcademicStats.DIPLOMA_EARNED'= "Yes" && ThisItem.'Graduation Location' <> "-", Color.LightGreen, ThisItem.'U_STU_AcademicStats.DIPLOMA_EARNED' = "No", Color.LightCoral)