web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Check if all Subtasks ...

Power Apps

Answered

Check if all Subtasks are at 100%

(0) Share

Report

Report

Posted on by niklasjegg

539

Hello,

i am developing a task Planner app from a SPO list.

I have 2 Task Categorys. MainTask and SubTask in the same list. The filtering and only showing respective tasks works fine.

The Maintask hast a Text Column with TaskID that is generated. e.g. IN-0001 and type MainTask and the Subtast hat the ID IN-0001 and type SubTask.

I can edit each of these tasks separately in a popup.

I have a "progress" column with the range of 0 to 100 (0,25,50,75,100).

I want te be able to only change the Status of the Maintask if all the respective Subtasks are at 100.

How can i achieve this? is this even possible?

There could only be 1 SubTask or there could be 10 Subtasks

Thank you and BR Niklas.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay...

Use count rows to check how many sub tasks are associated to that task and, after that, use count rows to check how many are at 100

If first count rows = second count rows, it means that all the sub tasks are at 100.

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Verified answer

niklasjegg 539 on at

Like
a
(1)

Report
Copy link

Link copied!
@Nogueira1306 i am sorry this was a bit confusing.

I had a workaround with a second gallery i needed anyway. The Gallery shows all items that are subtasks and have the same "TaskID" 🙂

If( Details_Progress_Input.Selected.Value = "100", ForAll(Details_Subtasks_Gallery.AllItems, If( Progress <> "100",Notify("Each Task has to be at 100 percent!",Error) And Reset(Details_Progress_Input) ) ) )
Thanks for the help tho. The Countrows would have also worked.

Was this reply helpful? Yes No

Join the conversation