Power Apps Cheat Sheet for Gallery Filter and Search Feature

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.

Power Apps- Make field visible based on Option Field Value- Galleries

In the Visible Property:

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

 

Power Apps- Galleries- Delegation- Sharepoint List - Cheater Code - Search by text input over 2000 items

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.

Power App-Power FX- Galleries - if this field value equals NULL then display another column value

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"

Capture UserName of submitter- Power Apps to SharePoint List

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

 

laugh

Power Apps Cheat Code- Filters DataSource by All but have extra condition

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

Get DataVerse Choice Column Text Value with Power Automate

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":"-","

Power Apps Gallery Items Color and Icon displayed based on Dataverse Column Value and Yas/No Columns

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)

Center Align Text Labels, Buttons, forms and more in Power Apps

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

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

 

Saved a ton of time!  Thanks to Micheal Alex!

PowerSchool Student Search Queries Operators

I am always trying to find these. Easy reference.

Search Operators

Pages

Subscribe to Melinda Cozza - Power Platform and CMS Developer RSS