cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Getting data from two excel sheets or one excel sheet with two different table

Hello,

 

I want to get the data from two excel sheet in one view in powerapps portal. If powerapps recognise two tables from one sheet that would be also fine.I want to display in the form of table, with rows having data from different sheet and column from another.

 

Thanks.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Getting data from two excel sheets or one excel sheet with two different table

Hi @yaksh108 ,

Could you please share a bit more about your scenario?

How do you display the data from your Excel file? Using PowerApps canvas app or PowerApps Portal?

 

If you want to display data from your Excel file within a Portal, I afraid that there is no way to achieve your needs in PowerApps currently. The Portal only support CDS Entity as data source.

 

If you want to display the table data from different sheets within a canvas app, you could consider merge the two different table data into a single one collection, then use the collection as data source in your app. Then add a Data Table control in your app, set the Items property to the merged collection.

I assume that there is a relationship between the two different tables. Then you could use the following formula to create the merged collection:

ClearCollect(
             MergedCollection,
             AddColumns(
                        Table1,
                        "Column1FromTable2",
                        LookUp(Table2, PrimaryKeyColumn = Table1[@ForeignKeyColumn], Column1FromTable2),
                        "Column2FromTable2",
                        LookUp(Table2, PrimaryKeyColumn = Table1[@ForeignKeyColumn], Column2FromTable2),
                        "Column3FromTable2",
                        LookUp(Table2, PrimaryKeyColumn = Table1[@ForeignKeyColumn], Column3FromTable2),
                        ...
                        ...
             )
)

Note: If there is no relationship between the two tables, I afraid that there is no way to display data from two excel sheet in one view in PowerApps app.

 

Currently, recognizing two tables from one Excel sheet is not supported in PowerApps. If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Getting data from two excel sheets or one excel sheet with two different table

Hello, 

 

I am using the PowerApps portal to get the data and I want to display it in the form of a table. I am attaching a screenshot for better understanding.

 

The first three-row in the attached picture grabs data from one excel sheet and the column header grabs the data from another table. rest data are checkboxes.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,441)