Nested Sharepoint List

(0) Share

Report

Posted on by JP-21081032-0

I have 2 sharepoint list

BillTo contains a list of project codes to bill to - Title = cost centre code, Active = Yes/No
BillToAssign contains an employee reference -
Title = name of person cost centre assigned to
BillTo = lookup record of Cost Centre

I have the following code to show in a drop down list all those records that are not assigned to the current user

Filter(
 Choices([@BillToAssign].BillTo),
 Not(
 Value in Concat(
 Filter(
 BillToAssign,
 Title = currentUser.FullName
 ).BillTo,
 BillTo.Value
 )
 )
)

However I only want to display those values that are active = "Yes"

Any assistance would be greatly apreciated

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CountJuju ,

Could you tell me:
Is 'Active' a 'Yes/No' Column?

If my assumption is correct, please try this formula on Items property of dropdown control:
Filter( ForAll( Filter( Choices([@BillToAssign].BillTo), Not( Value in Concat( Filter( BillToAssign, Title = currentUser.FullName ).BillTo, BillTo.Value ) ) ) As A, If(LookUp([@BillTo],ID=A.Id).Active=true,A)),!IsBlank(Id))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
JP-21081032-0 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft Thank you - works a treat

Was this reply helpful? Yes No