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