Blogs

Sort then search items Power Apps Gallery

Sort (Search(
    If (Dropdown4.Selected.Result = "All",'DATASOURCE', Filter('DATASOURCE','ColumnName' = Dropdown4.Selected.Result)),
    SearchBox.Text, "ColumnName") ,Created,Descending)

****Created is the column that stores the created date in my Sharepoint list

 

Create Item in Child SharePoint list if does not exist or Update an existing item in a child sharepoint list from a master sharepoint list - Power Automate

I have two lists-

Master and the Child list
I am using the Master List's ID column and I created an integer column in the Child List called "CaseID". CaseID is my Key Column.

Here is the Flow.

PowerApps- Field Validation in the submit form function. phone and Email

For the Icon or button you use for a form submit.  Place formula in the "OnSelect" property.
(Tests for "true", a true result: submit the form, false result: it displays an error message on top of the page.)

PowerApps- Phone number validation - in Label

Shows error in label

!IsBlank(DataCardValue7_1.Text) And !IsMatch(DataCardValue7_1.Text,Digit & Digit & Digit & Hyphen & Digit & Digit& Digit& Hyphen & Digit & Digit & Digit &Digit)

 

PowerApps- Email validation formula checking for valid email format

This Formula can go into the "OnSelect" property of the save or submit button.

 

If(IsMatch(DATACARDNUMBER.Text, 
           "^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$"
   ),
   SubmitForm(FORMNAME),
   Notify("Email not valid", NotificationType.Error)
)

 

This formula can go into a label to use on your screen.

 

Multi-Screen Form in PowerApps- Display column/ field value in a custom label

This is a very easy solution but finding in on the internet was not. So I am adding it here.

In your powerApp insert label then add the below to it's "Text" Value

PowerApps, SharePoint List, PowerAutomate- Public submission. Move item where user cannot edit any further.

The Scenario:
We are using PowerApps as a UI for organization wide users to submit Grant applications. Forms is not an option because users need to come back in and be able to edit. So I created a multi-screen form app that saves the users progress section by section.

Funny issue in powerapps- too early in the AM. Date format displays strange word.

So it is way too early in the AM for issues to be coming up.  My brain couldn't comprehend this issue when it came up.

My date format was displaying " lulv" on my app.  A google search brought up some naughty sites and I was like "Whaaaaat?" LOL

 

Power Apps get rid of Blank Value in dropdown filters -ClearCollect

The issue.  Using a DISTINCT function in my dropdown brought in the blank value some records had in that column(Field). I didn't need the filter to have the blank value for filtering.

Display: none; for ICONS to stop the blinking- CSS Font Awesome- Drupal 7

Here's the css code from an unordered list

I believe it is the "SVG"  selector that takes away the blinky thing.

 

Pages

Subscribe to RSS - blogs