Melinda Cozza - Power Platform and CMS Developer

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.

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.

Pick your trigger; and click "Create"

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.

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.

Add a label with below:

Add your text into the Text property:

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)

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.

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.

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.

Here is the formula:

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