Power Platform Community Forum Thread Details

Hello - hoping someone can advice on how to build an app to start and end tasks.

My app has two dropdowns, name and task. Then i have a start task button and an end task button.

I want my app to only allow users to have one open task at a time, so if they begin a task and close the app, when they re-open and attempt to start a new one, or even end a task they havent started yet, to not allow them to proceed.

When the start task button is selected, a sharepoint item is created. When end task is selected, that record will be patched with the date and time.

I have a sharepoint list which will store name, task, status ('in progress', 'task complete'), start time, end time.

Note, it will be a service account logged into the app, so the dropdown for name is required.

Any help appreciated!

Thanks

Categories:

Building Power Apps

@Jap11
I feel if you follow below steps/logic it can help you

BUILD TASK TRACKER APP – ACTION STEPS
1. Set up SharePoint List

Columns:

Name (Text)

Task (Text or Choice)

Status (Choice: "In Progress", "Task Complete") - this is important

StartTime (DateTime)

EndTime (DateTime)

2. Dropdowns in Power Apps

drpName.Items

["Alice", "Bob", "Charlie"] - name of your users

drpTask.Items

["Task A", "Task B", "Task C"] - tasks name

3. Start Task Button (btnStartTask.OnSelect)
If(
CountRows(
Filter(
YourSharePointList,
Name = drpName.Selected.Value && Status = "In Progress"
)
) > 0,
Notify("Task already in progress", NotificationType.Error),
Patch(
YourSharePointList,
Defaults(YourSharePointList),
{
Name: drpName.Selected.Value,
Task: drpTask.Selected.Value,
Status: "In Progress",
StartTime: Now()
}
)
)

4. End Task Button (btnEndTask.OnSelect)
Set(
openTask,
First(
Filter(
YourSharePointList,
Name = drpName.Selected.Value && Status = "In Progress"
)
)
);

If(
IsBlank(openTask),
Notify("No active task to end", NotificationType.Error),
Patch(
YourSharePointList,
openTask,
{
Status: "Task Complete",
EndTime: Now()
}
)
)

5. Disable Buttons Based on Task Status

Start Task Button – DisplayMode:

If(
CountRows(
Filter(YourSharePointList, Name = drpName.Selected.Value, Status = "In Progress")
) > 0,
DisplayMode.Disabled,
DisplayMode.Edit
)

End Task Button – DisplayMode:

If(
CountRows(
Filter(YourSharePointList, Name = drpName.Selected.Value, Status = "In Progress")
) = 0,
DisplayMode.Disabled,
DisplayMode.Edit
)