leader's blog

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)

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")

if [StudentsinHHID] = 1 and [Un_Excused_Abs_HHID] > 59 then "AttendanceHold" else if [StudentsinHHID] = 2 and [Un_Excused_Abs_HHID] > 119 then "AttendanceHold" else if [StudentsinHHID] = 3 and [Un_Excused_Abs_HHID] > 179 then "AttendanceHold" else if [StudentsinHHID] = 4 and [Un_Excused_Abs_HHID] > 239 then "AttendanceHold" else if [StudentsinHHID] = 5 and [Un_Excused_Abs_HHID] > 299 then "AttendanceHold" else if [StudentsinHHID] = 6 and [Un_Excused_Abs_HHID] > 359 then "AttendanceHold" else if [StudentsinHHID] = 7 and [Un_Excused_Abs_HHID] > 419 then "AttendanceHold" e