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,
