Share
Report
44I've run into a stone wall on this one. Maybe someone can help me or give me some ideas. All my ideas lead to dead ends.
The scenario:
We need to dynamically populate pay types and load in payment amounts for those pay types by invoice.
Current semi-successful implementation:
I'm using a flow to run a SQL query to get the invoices and the invoice totals placed into a vertical gallery. Since the pay types have to be dynamic, I have nested a horizontal gallery with all the active pay types inside that original gallery. This does work; however, because of the # of pay types and number of rows of invoices, the loading of the payment amounts into the app is extremely slow (think of the speed of doing 260 x 15 lookups minimum).
My idea where I have reached said dead end:
Place the horizontal gallery inside of another vertical gallery where the new vertical gallery is a pivot table of the pay types by invoice (vertical gallery with rollup data -> vertical gallery a pivot table with all active pay type data by invoice -> current active pay types). This is not a solution though because you cannot dynamically specify column selection in PowerApps. For this to work, I need to be able to do something like Parent.ColumnNameFromInsideGallery which is not possible. I am unsure if maybe this is now possible in the new advanced code editing feature, but I haven't taken a look at that yet and would have to get familiar with YAML. Or perhaps if I was to build a custom component that could do this somehow with JavaScript or some other code?
All responses (
Answers (
