Look up another table in a ForAll

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Probably an easy one but I'm stuck. Hopefully someone can help please.

I have a button which will create a number of different Planner tasks. The OnSelect formula is:

ForAll(Tasks,Planner.CreateTaskV2(OPGplanId,TaskTitle,{bucketId:TestbucketId,dueDateTime:DatePicker1.SelectedDate+TaskAddDays,assignments: LookUp(Roles, EmployeeRole = TaskAssignedTo, EmployeeId)}))

All is working fine, except the 'assignments' part - I don't think I'm quite getting my head around the LookUp. I am trying to find the id for the assignments on another table that lists all the roles.

My 'Tasks' table looks like:

Task Title	TaskAddDays	TaskAssignedTo
Test task 1	1	Head of Shared Services
Test task 2	2	Head of Customer Services
Test task 3	3	PRO

My 'Roles' table looks like:

EmployeeRole	EmployeeId
Head of Shared Services	one@sample.com
Head of Customer Services	two@sample.com
PRO	three@sample.com

Can anyone help please?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

wyotim 2,545 on at

Like (1)

Report
Copy link

Link copied!
Hey @Anonymous, try this:

ForAll( Tasks, Planner.CreateTaskV2( OPGplanId, TaskTitle, { bucketId: TestbucketId, dueDateTime: DatePicker1.SelectedDate + TaskAddDays, assignments: LookUp(Roles, EmployeeRole = Tasks[@TaskAssignedTo], EmployeeId) } ) )

These nested operations can be tricky to sort out but my guess is that using the disambiguation operator should help the LookUp to operate in the correct scope.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you, @wyotim, for the fix and for the link. I'll go do some reading!

Was this reply helpful? Yes No