It's Drupal Power Platform Girl!

DrupalGirl Posts- Melinda Cozza

When an event is cancelled in PowerApps/ Dataverse, delete the event from SharePoint Calendar list with Power Automate

Here's is my flow

When a user modifies their trip record and the "Would you like to cancel" field/choice column is equal to "Yes" (really field value: 115650000) then delete that record from SharePoint Calendar and the dataverse. This flow also send a email notification to the user and the person in charge of trip reservations.

 

Display User's Full Name from Created By field Dataverse column to use in PowerAutomate

Add a "Get Row ID" action to your flow and with the table name "Users" in "Row ID" add the created by field from your trigger step, "When a row is added, modified or deleted". See below

 

 

Get the Label property of Dataverse choice Column for PowerAutomate- PowerPlatform

I am using the "label" of a choice value column for PowerAutomate to create an item to a sharepoint list. I want the column to display the "Label" of the field and not the boolean number.

Expression based on your action step

outputs('TransRequests')['body']['crd1d_trippurpose@OData.Community.Display.V1.FormattedValue']

Breaking down the expression

Change visible property based on datacardvalue via Dataverse colunm value selected- PowerApps

 

In the DataCard's "Visible" Property.

Based on Dataverse Choice Column:

If(DataCardValue.Selected.Value in "Your Colulm Value",true,false)

IE: If(DataCardValue34.Selected.Value in "New location",true,false)

When your newly created Dataverse column does not show up in your "Add Record" form

This drives me crazy because I can never remember why this happens and I have to search for the answer. Make sure to Save then Publish! The new column will not show up on the form unless you publish the form.

 

Style daily Power Automate email in a HTML Table

To add on to one of my previous posts, here is how you style your daily email in a nice HTML table.

1. set up the trigger are "Recurrence"

Power Automate- Twitter sign in/ connection issues - the account being added is already logged in

Just a problem I ran into and the solution that fixed it.

I am creating a Social Media Hub so our admistrators can create the content for social media posts and post them to our various social media platform accounts in one place. (Instead of needing to go to each social media site and post them individually)

So my problem was, I created a test twitter account to use for testing purposes through my gmail account.

Part 3! Add your custom connector to PowerAutomate to auto post to Drupal 9! from a SharePoint item list

My flow is :

When an item is created or modified and the publish field value equals "Publish" then get the item and send field values to Drupal and create a job posting for the public to view.

smiley

Pick your trigger; and click "Create"

Part Two: Post on Drupal 9 from PowerPlatform build a custom connector in PowerApps, SharePoint, PowerAutomate, Dataverse

Part Two!

We are going to use what we learned from PostMan to create our own PowerPlatform Connector to easily post to a Drupal 9 website.

1. Export your PostMan Collection.

Part One: Post to Drupal 9 from Dataverse Data using PowerAutomate and PostMan - Building the API

First we need to build the API so PowerAutomate can talk to Drupal.

I am developing this for a School Distrct HR Power Platform.  This piece is for the Job Board where HR can get a staffing request from a supervisor.  From there they can create a job posting from with in the Power Platform. That posting will go public on a Drupal 9 site.

I choose to use Drupal instead of Power Portal cause it's cheaper. laugh

 

No results message for Power Apps Gallery

Add a label with below:

Add your text into the Text property:

Filter Power Apps Gallery by Created By and current user. (Display content that the logged in user authored or created)

In PowerApps in your Gallery's Item area use the following formula

Filter(Data source,'Created By'.Email=User().Email)

Or

Filter('Data source','Created By'.DisplayName= User().FullName)

When a user misses an appointment date, send email notification - Power Automate - SharePoint List

What I used it for.

My platform automatically schedules an appointment for users.  If the users do not check in by a certain time on the day of their appt. the system sends them an email letting them know they missed their appointment.

Here's the flow:
This is the entire flow.  Scroll down to get the steps.

Skipping weekend for SharePoint Calculated Columns- Due date type stuff

I need to allow the staff to enter a date and base on that date, administer tests based on that date.There will also be a flow that notifies another user that they are scheduled to take a test.

I created Calculated columns so it would automatically generate the dates as soon as the staff members enter a start date.
We do not test over the weekend so I needed to take out saturdays and sundays.

Test are two days apart during a normal work week. So I need every one who starts or completed a test on Thursday or Friday to complete their next test on the following Monday.

Send a daily email with all SharePoint Items that were created today- Power Automate

 

This flow will send a daily email that contains all the SharePoint Items that were created that day.

My Flow is set up to fire off at 6:15AM and 4:15PM. (You can set up times in the "Advance options")

1. Step one set up the trigger as a Recurrence.

Change text color based on field value- Power Apps Galleries

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:

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

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.

Pages