leader's blog

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

Coalesce(ThisItem.NewLocation.Value, 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)

Add this to the "X" property of you element.

(Parent.Width / 2) - (Self.Width / 2)

Saved a ton of time!  Thanks to Micheal Alex!

I am always trying to find these. Easy reference.

Search Operators

I wanted my script to look at values but ignore the "Null" values for the comparison 

Table.AddColumn(#"Split column by delimiter 1", "PSStudentAddressMatches", each if [PSMailingAddress.1] <> [PSMailingAddress.2] and [PSMailingAddress.2] <> null  then "PS Address Flag"

else if [PSMailingAddress.1] <> [PSMailingAddress.3] and [PSMailingAddress.3] <> null  then "PS Address Flag"

else if [PSMailingAddress.1] <> [PSMailingAddress.4] and [PSMailingAddress.4] <> null then "PS Address Flag"

Table.AddColumn(#"Attendance Hold", "AllHHIDHold", each if Text.Contains([HHIDHomeless], "Homeless") then "OK" else if Text.Contains([ComputerHoldonHHID], "Hold") or  Text.Contains([HotSpotHoldonHHID], "Hold") or  Text.Contains([AddressHold], "Hold") or  Text.Contains([AttendanceHoldonHHID], "Hold") then "Hold" else "OK")