cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vffdd
Super User
Super User

looking for most efficient way to join 2 tables into a 3rd

I have 2 Tables 

For example

1.

 

AB1 Apple
AB2 Orange
AB3 Lettuce
AB4 Cucumber
AB5 Pear

 

Table 2

AB1 Fruit
AB2 Fruit
AB5  Fruit

 

I would like a 3rd table that show only the records in Table 1 that are NOT in Table 2.. So for example

AB3 Lettuce
AB4 Cucumber

 

I then need to use that table as a datasource in powerapps.

 

I'm trying to figure out the most efficient way to do this?  Yes I could do it with collections in Powerapps.. however is there a better way to do it at the dataverse end?  or maybe should I even create a dataflow that creates this table?  suggestions welcome 🙂

 

TIA

1 ACCEPTED SOLUTION

Accepted Solutions
vffdd
Super User
Super User

Thanks @AhmedSalih  I've actually decided to do it in the powerapp itself and not create a 3rd table using this method.

https://youtu.be/U-WN4OFZ1kw

 

 

View solution in original post

2 REPLIES 2
AhmedSalih
Super User
Super User

Hello, @vffdd, you can achieve this via Dataflows/Power Query. Create your third table in Dataverse and then create a Dataflow and implement a Join in the power query. 

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

 

vffdd
Super User
Super User

Thanks @AhmedSalih  I've actually decided to do it in the powerapp itself and not create a 3rd table using this method.

https://youtu.be/U-WN4OFZ1kw

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,940)