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

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I have 2 Tables

For example

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Copy link

Link copied!

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