cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kran
Level: Powered On

Display Multiple entities in a list

Is it possible in a Canvas app to join multiple entities and display in a list? If not possible directly, perhaps with help of a azure function?
1 REPLY 1
Community Support Team
Community Support Team

Re: Display Multiple entities in a list

Hi @Kran,

Could you please share a bit more about your scenario?

Do you want to combine/join multiple data source within a PowerApps app, then display the combined result within it?

Further, could you please share a bit more about your data source?

The user @itsmeqp and @boonyar have faced same issue with you, please check the response within the following threads:

https://powerusers.microsoft.com/t5/General-Discussion/How-to-join-2-data-sources/td-p/75631

https://powerusers.microsoft.com/t5/General-Discussion/Can-I-add-fields-from-multiple-data-sources-i...

 

On your side, if there are some unique join keys between your multiple entities, I think the AddColumns function could achieve your needs. The standard formula as below:

AddColumns(Table1, "Region", LookUp(Table2, Name = Table1[@Name], Region))

Note: The Name column represents the unique join key between Table1 and Table2.

More details about the AddColumns function, please check the following article:

AddColumns function

 

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.