Answered

Task separated into parts

(0) Share

Report

Posted on by GatorGrad0929

Hello,

I am building an app where multiple project directors can be assigned a task. How can I check to see if each project director has marked their part complete before the app moves to the next step in the workflow?

For example, someone puts in a request to have their room cleaned. John is tasked with sweeping. Mary is tasked with cleaning the windows. Tim is tasked with vacuuming. The room cannot be marked complete until each person marks their task complete.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there

there are a few ways but first of all how is the tasks being assigned to them and how do they update it. once they update the task you can used that to check the "progress".

let s you say you have a SharePoint List mySpList and a column TaskStatus. In PowerApps you could have a collect ClearCollect(colTaskStatus, filter(mySpList, TaskStatus = "Not Complete")). Insert a gallery control and set the datasource to colTaskStatus. Add a lalbel to the galler for the name of you project manager "labelName"

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GatorGrad0929 ,

Could you please share more details with your app? If you're just talking about how to do it, just change the status to Finished when each part is done, and then just check if every related parts to the task are done.

Here are some data structures for your reference:

Task:

TaskID TaskName Status

T001 Room Cleaning UnFinished

Task Details:

TaskID ProjectDirector Status

T001 John Finisned

T001 Mary UnFinshed

T001 Tim Finisned

Hope this helps.

Sik

Was this reply helpful? Yes No
GatorGrad0929 21 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft @rubin_boer

I have the app set so that when each project director completes their task, the status changes from "Pending" to "Approved".
I'm stuck on how to have the app check to see if each individual task as been completed before marking the entire project complete.

Thank you.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @GatorGrad0929 ,

Try with the following logic criterion, check if "Pending" is in the Status column of filtered record by Task. When All parts of task are done, the button turns Editable from Disable.

//DisplayMode property of button to mark the entire task complete. If( "Pending" in Filter('Table Name', TaskName="Room Cleaning").Status, DisplayMode.Disabled, DisplayMode.Edit)

Hope this helps.

Sik

Was this reply helpful? Yes No
GatorGrad0929 21 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft

This was it! I just had to tweak it a bit and filter the SharePoint list instead of the table, but it worked perfectly!

Thank you!

Was this reply helpful? Yes No