Answered

Checking if all subtasks are complete

(0) Share

Report

Posted on by bjdshp

I need something similar to this where it checks to see if a record exists.

https://powerusers.microsoft.com/t5/General-Discussion/Checking-to-see-if-a-Record-exists-if-it-does-then-Patch-an/td-p/16623

I have a situation where multiple people are assigned subtasks to a major task, and it can't be marked approved until all people have performed the task.

Here is what I am using.

If(LookUp(Filter(MOC_Approvals,vID.ID='MOC ID'),Status="Approved",true)<>true,UpdateContext({vSuperCheck:false}),UpdateContext({vSuperCheck:true}));

The problem I realized this morning is that lookup will return a true on the first item marked approved, but I need it do something like a ForAll. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mike8 1,330 on at

Like (0)

Report
Copy link

Link copied!

Hello,

If(
!LookUp(Filter(MOC_Approvals,vID.ID='MOC ID'),!(Status="Approved"),true),
UpdateContext({vSuperCheck:false}),UpdateContext({vSuperCheck:true}));

Can you try the formula above?
It checks if there is a record that its status is not approved. If it exists does nothing. If it doesn't find any records that status is not approved means that all are approved 🙂
Hope it works

Was this reply helpful? Yes No
bjdshp 25 on at

Like (0)

Report
Copy link

Link copied!

Thanks for pointing out the obvious! That worked, I appreciate the help.

Was this reply helpful? Yes No