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)


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"


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.

Remove the comma from SharePoint Item List Integer Number column

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

Power Automate Power Apps - include an Email link in PowerAutomate email body to an item in a power apps.

****Update- Due to changes in Power Apps, you must make sure that you have the "Enable Navigation function in App.OnStart" ticked in your App's Settings. Located in Settiings> Upcoming features> Retired


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



Subscribe to Melinda Cozza - Power Platform and CMS Developer RSS