It's Drupal Girl!

Change text color based on field value- Power Apps Galleries

Mon, 12/06/2021 - 11:45 — melinda

Here is the formula:

If(ThisItem.ColumnName.Value = "Issue", Orange, ThisItem.ColumnName.Value = "Risk", Red, ThisItem.ColumnName.Value = "Dependency", Blue, Black)

Adding drop down filter control for Power Apps based on Choice column:

Mon, 12/06/2021 - 10:53 — melinda

1. Add the formula in your apps "OnStart"

ClearCollect(YourCollectionName,Choices('SharepointList'.ColumnName))

Your PHP is too old for Drupal 9- Liquid Web VPS Apache Server

Fri, 12/03/2021 - 17:49 — melinda

Took me a few minutes to figure this out on my VPS so I thought I would share it.

One my liquid web server in the WHM, type in "PHP" in the search. Then Click on MultiPHP Manager.

Remove the comma from SharePoint Item List Integer Number column

Wed, 12/01/2021 - 13:05 — melinda

On you "Number" column select the drop down option "Column settings"

Power Automate Power Apps - Email link to item in a power apps.

Tue, 11/30/2021 - 15:05 — melinda

I use this Flow to send an email to the supervisors any time a record was updated using our Power App. I did not want to use "Link to Item" because I used power apps to layout the Item forms. If I sent the Supervisors to the Sharepoint item, it looks a lot different and causes confusion with my not so tech savvy supervisors.

Below are instructions on how to create a link directly to the item in the Power Apps.

Changes in your power app for the redirect.

1. Change "OnStart" in your App Settings

Sort then search items Power Apps Gallery

Tue, 11/30/2021 - 13:07 — melinda

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

Tue, 11/23/2021 - 23:39 — melinda

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

Mon, 11/15/2021 - 12:27 — melinda

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

Mon, 11/15/2021 - 11:10 — melinda

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

Mon, 11/15/2021 - 10:12 — melinda

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

Mon, 11/08/2021 - 08:34 — melinda

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.

Tue, 10/26/2021 - 23:30 — melinda

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.

Wed, 10/06/2021 - 08:08 — melinda

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

Wed, 09/15/2021 - 12:47 — melinda

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

Mon, 09/13/2021 - 11:08 — melinda

Here's the css code from an unordered list

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

Power BI- Embedded reports- remove navigation tabs from display

Mon, 08/23/2021 - 08:32 — melinda

Issue:
How to Hide Power BI iFrame Embedded Report Tabs

Show the navigation tabs:

<iframe width="1140" height="541.25" src="https://app.powerbi.com/reportEmbedYOUR-REPORT_URL" frameborder="0" allowFullScreen="true"></iframe>

Remove Hard Wax off eyelashes use a hairdryer! Not a tech post but important information

Thu, 08/05/2021 - 16:54 — melinda

Haha! I believe this is important information for anyone who uses hard wax for eyebrow hair removal.

Upon waxing my eyebrows I dripped hard wax onto my eyelashes. It was horrible.

I tried ice like some posts said but it did nothing. I tried lotions and oils, nothing.

I waited it out to see if it would just break down by itself... it was laughing at me.

So finally, I read somewhere to use a hair dryer to soften the wax. BINGO! The hard wax melted and I was able to brush the wax off my eyelashes without the lashes coming out.

Add JSON code snippets to your PowerAutomate Flow for dynamic content

Tue, 08/03/2021 - 13:12 — melinda

Add JSON array to your flow to add attachement to your SharePoint List using PowerAutomate Flows.

1. Add step "Parse JSON"

PowerAutomate Parse Attachment array for flows

Tue, 08/03/2021 - 12:56 — melinda

To parse arrays in PowerAutomate you need to get the Json code snippets.

In this example I am getting the Attachment aray of a MS Form for one of my flows.

Use the flow to which you are going to get the array from:

1. Test the flow.

2. After the run get the "Get Response details" outputs.

Create SharePoint List item from MS forms and add attachments to SharePoint List

Tue, 08/03/2021 - 11:59 — melinda

Situation: I have a MS Form "New hire questionnaire" that collects information from a New Hire that will be starting with our company. I am using MS Forms, which is available to the public facing user without authentication. So no need to sign in. This would be the first step on our automated "Onboarding" process. This MS Form will populate a "New Hire" lookup list so the HR department can use the data to start a process for the new hire to be ready to go on their first day of work.

Main menu

DrupalGirl Posts- Melinda Cozza