Power App- If Text Input box is blank how to save to Sharepoint list on a Patch function

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

}

);

Power Apps Galleries- Show all events/Time slots for the person (Person Column Sharepoint) then filter by combobox date

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)

 

Power Apps- Patch Sharepoint List with Time Range, create time slots, and save to person column

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 Sharepoint list Date Column

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

            ),

Data Flow - Replace prefixes of mailing address

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"

Power Apps- Disable button for 3 second after clicked and display notification to prevent multi-clicks

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.

 

Power Apps- Order your Dropdown options for Distinct Text Sharepoint list Column Values

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:

Sharepoint List- Json for when a text column is not Null change background color of the Name column

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)

 

Pages

Subscribe to Melinda Cozza - Power Platform and CMS Developer RSS