Power Apps- Order your Dropdown options for Distinct Date Values and format date for Power Apps from a Sharepoint list Date Column

In your Combobox or dropdown "Items" property:

Sort(

    ForAll(

        Distinct(

            YourSharepointList,

            YourDateColumn

        ),

        {

            DateSort: Text(

                Value,

                "yyyymmdd" //For an accurate Sort

            ),

Table.ReplaceValue(#"Step Before Name",

each [YOUR COLUMN NAME],

each if [YOUR COLUMN NAME] ="NORTH" then "N"

else if [YOUR COLUMN NAME] ="SOUTH" then "S"

else if [YOUR COLUMN NAME] ="WEST" then "W"

else if [YOUR COLUMN NAME] ="EAST" then "E"

else [YOUR COLUMN NAME],

Replacer.ReplaceText, {"YOUR COLUMN NAME"})

THE OTHER WAY

Table.ReplaceValue(#"Step Before Name",

each [YOUR COLUMN NAME],

each if [YOUR COLUMN NAME] ="N" then "NORTH"

else if [YOUR COLUMN NAME] ="S" then "SOUTH"

I don't know why but this was extremely difficult to find on the web.

This is how to add a button to a Power App that will disable after clicked, display a notification, and then re-enable after three seconds.

I added a Dropdown list that filters a gallery by Manager Name.

Using distinct Manager Names as option for my drop down were is a crazy order.

I want the options on the dropdown to be alphabetical so Managers are easier to find and select.

Here is the cheater code for the Items property of your dropdown:

My Parse JSON action was giving me this:
"{""Value"":""Allentown""}" as my text Value for my CSV

Change the background color of one Sharepoint List column based on if another Sharepoint list column is empty, blank or null.
*****Note: This will only work correctly if your Multi-Line Text / String Column is Plain text. Make sure the column is set to plain text. (Not Rich text or Enhanced rich text)
 

Instead of looking for the Sharepoint list by Title, look for it by ID.

_api/web/lists/getbyid('%7B23bb13e3-ed19-42c4-9dd6-524136b89925%7D')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})

How to find your sharepoint list ID?

When trying to get the column name from a "Send an HTTP request to Sharepoint" action, because I was trying to get the column value BEFORE the value was changed. I need to log the old value into a "log" column.

In the Sharepoint List,  I named the column "2026-Assignments" and the column name looked like, "_x0032_026_x002d_Assignments" when I looked at the columns url in list settings. Example below:

I want percentage of days a student missed out of the school year. 

Add a custom column and put:

if [DaysEnrolled] <> null and [DaysEnrolled] <> 0 then

    Number.Round(([UNEXCUSED_ABS] / [DaysEnrolled]) * 100, 2)

else

    0

Create a dynamic date range with today's date being the end date. Counts all the "Business" days with no weekends or holidays.

let