Announcements
Hey guys, here is my problem. I have two tables
Table 1
Table 2
Am trying to filter only the valid ID from table 1 to find the Eval on table 2.
Thanks for your help
Hi @loopingmurdock ,
One way below = it would help if the two Id columns were not names the same.
AddColumns( Filter( Table1, Id in Table2.Id ) "Eval", LookUp( Table2 As a2, a2.Id = Id ).Eval )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hey, thanks for the answer, keep getting error, i change id.
Average(AddColumns(Filter(Evaluation_Statuts, ID_Evaluation_ES in Responds_Evaluation.ID_Evaluation_ ), "Eval", LookUp( Responds_Evaluation As a2, a2.ID_Evaluation_ = ID_Evaluation_ES)).Eval
Its for a average, but get an error that eval_ is not find
I cannot see your data and have structured this assuming the references are correct
Average( AddColumns( Filter( Evaluation_Statuts, ID_Evaluation_ES in Responds_Evaluation.ID_Evaluation_ ), "Eval", LookUp( Responds_Evaluation, ID_Evaluation_ = ID_Evaluation_ES ).Eval ), Eval )
Thank you sir.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 405 Super User 2026 Season 2
Mohsin Ali 368
WarrenBelz 244 Most Valuable Professional
