Melinda Cozza - Power Platform and CMS Developer

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)

1. Add the formula in your apps "OnStart"

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

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.

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

****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 (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

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.

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.)