Excel (more than 1 table)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone

I have 2 diferent tables on Excel:

> Courses

> Attendees

How can I connect the 2 tables (ID Course) and start to build a PowerApp?

I am starting to take my first steps...

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Pstork1 69,651 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

If you want the Excel tables to be Read/Write you'll need to store them on OneDrive or OneDrive for business. If they are Read only then you can store them in various places. Once you've decided how to use them then create the appropriate Excel connector and choose the storage location, the excel file and the two tables. They will then show as data sources in your application.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you describe more clearly about the function that you want?

In PowerApps, there's no direct way to connect two tables.

However, you could read or write items based on two tables.

The first step is to format your excel file.

All your data should be formatted to table. Or else, it can not be used in PowerApps.

Secondly, connect data source.

If you just want to read your excel files, you could select "import from excel" or "one drive".

If you want to update records, I suggest you update your excel files to one drive, and then choose one drive when connecting data source.

Please note that you need to connect with these two tables.

Thirdly, design your app. You could "connect tables" in this step.

Read/Write based on these two tables.

Best regards,

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help 🙂

I want to connect this two tables using Course ID.
Maybe Excel is not the best way to store data

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you describe more clearly about "connect these two tables"? what function that you want?

If you want to filter table2 based on table1's Course ID, you could try:

Filter(table2,Course ID in table1.Course ID)

If you want to combine table1 with table2, you could try:

ForAll(table2,Patch(table1,LookUp(table1,Course ID=table1[@Course ID]),{fieldname1:fieldname11,fieldname2:fieldname22,...})
//fieldname1 and fieldname2 is fields in table1, fieldname11 and fieldname22 is fields in table2
//in this way, table1 will be updated with the data of table2

Best regards,

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

Like
a
(0)

Report
Copy link

Link copied!

Perfect
Thanks!!!

Was this reply helpful? Yes No