cancel
Showing results for 
Search instead for 
Did you mean: 

INDIRECT References

In Excel, I can reference cells using Indirect() and spell out the cell and row number. The same can be useful in PowerApps for scalability.

Suppose you have a giant table with several columns. If you wanted to Collect, Patch, or Update, you would need to specify each column you want to modify in each instance. If you could tell those 3 functions to modify a column by indirectly looking it up in a gallery, you would have more flexibility. You would only need to edit the gallery entry if you want to change what all your other functions record with an Indirect ability.

Example: You have several buttons:

Collect(Collection, {Column1: item1})
Patch(Table, Defaults(Table), {Column1: item1})

If you want to change where item1 is recorded, you could have a gallery: ["Column1","Column2","Column3"]. You would do an indirect lookup to change what column does the recording.

Collect(Collection, {Indirect(LookUp(Gallery, item)): item1})
Patch(Table, Defaults(Table), {Indirect(LookUp(Gallery, item)): item1})

Comments
Level: Powered On

Yes! This is a great idea and would make this so much easier to use.