Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Linking two tables in the common datasource area of powerapps 'dataverse' in a form

(0) ShareShare
ReportReport
Posted on by 18

Hello 

 

I hope someone can help with this.  I am really new to this, so I would appreciate any help.

 

I have created a number of tables in the common datasource area of powerapps 'dataverse'.  It is for an ordering system.  I have a customer table, I have an order table, product table and a table that, for lack of a better name, is called invoice-product table.  I have them all working separately but am trying to clean them up for a newform.

 

At the moment I can go onto the Order page and select the customer, which creates an invoice id.  Then I can go onto a form linked to the invoice product table.  On this form I can select the invoice id, the product ids, and add a quantity.  

Ideally I would like to be able to automate the invoice id when going from the Order page to the invoice-product page.

 

Stacee_0-1613839234275.png

I am still trying to work out how to get the 'Customer Name' showing (as it is an id link).  But more importantly I would like to make it so that the OrderInvoiceID automatically selected the invoice number above, so that multiple product orders can occur and be assigned to that invoice.  But they are from two different datasources and are links/ids. (I am also going to try and amalgamate some of the buttons, once I have streamlined the form inputs). All my one to many relationships are connected and working.

 

Thanks

  • Stacee Profile Picture
    Stacee 18 on at
    Re: Linking two tables in the common datasource area of powerapps 'dataverse' in a form

    Thank you very much for this.  It was really helpful.  It did a majority of the work, and there are only a few formulas that I am not getting right, but will continue to dissect them. 

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Linking two tables in the common datasource area of powerapps 'dataverse' in a form

    @Stacee 

    There is a great sample of a Dataverse app that does everything you are asking and more.  It may take some effort but in my own experience it was really worth it.   If you run through the exercise you will learn how to set up your tables.  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/northwind-install 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard