create a joint table not working

(0) Share

Report

Posted on by Antonioclk

Hi, i have two tables and want to make a sort of merged one.

tableA

classID (int)
className (text)

tableB

classID
studentID

i need to generate a new joint table showing me:

classID
studentCount
className

how to do that? i tried adding this to a button but it gives me "error when trying to retrieve data..."

ClearCollect(
 myNewTable,
 AddColumns(
 GroupBy(
 tableB,
 "classID",
 "students"
 ),
 "studentsCount",
 CountRows(students),
 "className",
 LookUp(
 tableA,
 ThisRecord.classID = classID
 ).className
 )
)

should i do differntly? should i use a ForAll? i never used that function and it seems quite messy

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Antonioclk ,

Firstly logic says this should work (one small change), so try this first

ClearCollect( myNewTable, AddColumns( GroupBy( tableB, "classID", "students" ), "studentsCount", CountRows(students), "className", LookUp( tableA As aClass, aClass.classID = classID ).className ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps