Concatenate("Your Label Text " & CountRows(Filter('SharepointList', YourColumnName = "Your text condition" )))

For example: 
The below script looks at a couple conditions and counts the items that fit the criteria. This script is placed in a Text Label.
Concatenate("Diplomas that will need to be mailed" & " Total: " & CountRows(Filter('2025SummerGradCeremony', StatusColor.Value = "Yellow" And DiplomaEarned.Value = "Yes" )))

What it looks like on the Power App

length(outputs('Get_items')?['body/value']) = 0

I needed to get the values of a custom "Attribute" field we had in Active Directory in Power Automate.

https://graph.microsoft.com/beta/users/USERS_EMAIL_ADDRESS?$select=onPremisesExtensionAttributes

In my PA, I used a compose action to dynamically change the user email address.

Here is the error in Power Automate:
Test connection failed. Details: Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA inner exception: Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA clientRequestId: 5d4ab5a5-d136-81dd-e0ab-ab62dd76e609

Here is what it should look like:

When this happens,

1. Save App, Exit App and Re-Start App.

OR

Patch(

SharepointList, ThisItem,

{

Reserved: true, ReservedBy:User().FullName,

ReserverEmail: User().Email,

LearnerFullName: If(IsBlank(tiLearnerName_3.Text), Blank(), tiLearnerName_3.Text),

WhoFilledOutFormText: ddWhoFilling_3.Selected.Value

}

);

So if the user doesn't select a date I have in the combobox, the gallery will display all the time slots Melinda has available.

Filter(TimeSlots,CounselorName.DisplayName = "Melinda", IsBlank(ComboBox2_1.Selected.DateDisplay) ||EventDate = ComboBox2_1.Selected.DateDisplay)

I put this is my button's "OnSelect" property.

ForAll(

    Sequence(

        DateDiff(
/*This is my start and end times and it breaks it down into 1 hour or 30 minute or 15 minute time slots This still needs work*/

            ddStart.Selected.myDate,

            ddEnd.Selected.myDate,

            TimeUnit.Hours

        ) * If(

            ddLength.Selected.Length = 30,

            2,

             If(

            ddLength.Selected.Length = 15,

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"