Submitted by leader on Wed, 06/25/2025 - 14:04
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.
Submitted by leader on Wed, 06/25/2025 - 14:00
In the Visible Property:
If(ThisItem.ChoiceColumnName.Value = "-" Or ThisItem.ChoiceColumnName.Value = "No", false, true)
Submitted by leader on Thu, 06/05/2025 - 11:54
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.
Submitted by leader on Mon, 06/02/2025 - 11:09
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"
Submitted by leader on Wed, 05/28/2025 - 10:29
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

Submitted by leader on Mon, 05/26/2025 - 19:00
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",
Submitted by leader on Fri, 05/23/2025 - 02:31
Submitted by leader on Wed, 05/14/2025 - 13:51
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)
Submitted by leader on Tue, 05/13/2025 - 11:46
Add this to the "X" property of you element.
(Parent.Width / 2) - (Self.Width / 2)
Saved a ton of time! Thanks to Micheal Alex!
Submitted by leader on Thu, 04/24/2025 - 15:00
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"
Pages