Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - Power Apps Portals
Answered

Many To Many Form / Shopping Cart

(0) ShareShare
ReportReport
Posted on by 7

Hi there,

 

I am trying to implement a kind of shopping cart in my Power Apps Portal.

For this I have two tables set up in my Data Verse, one called "orders" and one called "products".

 

To me this is clearly a many to many relationship. One order can have many products and one product can have many orders.

So the many-to-many relationship is already set up.

 

I want my customers to be able to order multiple products (as many as they like would be optimal) with one order.

However, non of the given out-of-the box solutions (neither basic form nor advanced form) seem to be able to do that.

The lookup field for products in my order table is not multi select. So in a basic form a customer can only pick one product.

 

I tried using sub grids, since they allow multiple select. Sub grids do not work in insert mode however, which is expected since they only work in edit mode, so only once an order has already been placed.

 

Does anyone have an idea how to implement a shopping cart?

 

This would be an obvious use case of Portals to me. I am baffled that it is that hard to achieve something like that.

 

Thanks and best wishes,

Zack

  • Verified answer
    ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Many To Many Form / Shopping Cart

    Hi @Zackab ,

     

     Maybe some good news for you.

     

    ragavanrajan_0-1624500883135.png

     

    I can also confirm the portal template is already available to create 

     

    ragavanrajan_1-1624500982118.png

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Zackab Profile Picture
    7 on at
    Re: Many To Many Form / Shopping Cart

    Thank you both.

     

    Can we use the implicitly created intersect table, that is being created when declaring a "many to many" relationship in DataVerse, be used at  all in a Portal?

     

    Do we really always have to create the intersect table manually?

     

    (In my specific case my customers can not order more than one item of any given product. So order quantities do not need to be tracked.)

  • Fubar Profile Picture
    8,001 Super User 2025 Season 1 on at
    Re: Many To Many Form / Shopping Cart

    Its not really a many-to-many as you will need an intersect to hold the Qty ordered (the intersect has a Lookup to the other entities on it).

     

    Orders -< Product Ordered >- Product

     

    In the Above

    • Orders 1:M Product Ordered
    • Products 1:M Products Ordered
    • Products Ordered has a field to hold Qty, extended Cost etc etc

    Also, some of this Cart type of stuff is probably suited to using the portal Web API

     

  • ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Many To Many Form / Shopping Cart

    Hi @Zackab,

     

    Please have look at the following thread

    https://powerusers.microsoft.com/t5/Power-Apps-Portals/eCommerce-Website-Using-Power-Apps-Portal/td-p/621078 

     

    Again from a technical aspect, I haven't tried it yet. But based on the blog it should work. 

     

    Also, have a look at https://dynamics.microsoft.com/en-nz/commerce/resources/ 

     

    Better if you can consult with Microsoft for this to get a proper solution. 

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

     

     

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35