Power Platform Community Forum Thread Details

I’ve got a tough problem that I can’t figure out, but I’d love to see any ideas y’all have.

I’ve simplified the problem so that it’s easier to work with.

I’m building an app connected to a dataverse table. In this app, the end user inputs data about how many units of fruit X are in store 1 or store 2. They input this data into a table, and then push a button to send that data to the dataverse table.

This is what it looks like before they input data…

This is what it looks like after they input data…

I’m feeling tropical 😁🍍

When they’re done inputting the data, they send the data to the dataverse table by clicking the “Push to Backend Table” button.

This is the tricky part. It’s easy to make a patch statement that sends data to a dataverse table of this structure…:

But this is the structure of the dataverse table I need to send data to… this is harder:

Of course, I could have a couple ForAll – Patch statements (one for Store 1, and another for Store 2). But in reality when I build this app, the data entry table will have many more columns (i.e. Store 1, Store 2, Store 3, Store 4, … Store n), and so it would take forever for the patches to complete after the user clicks the “Push to Backend Table” button.

Any ideas?

Categories:

Building Power Apps