Unanswered

Can PowerApps do this - Matrix data input with rows from one list, columns from another, pivoted into single list?

(1) Share

Report

Posted on by Community Power Pla...

Hi all,

Apologies for what may be a really basic question, but perhaps due to my lack of PowerApps exposure yet, I've been unable to get any results from my searching.

Basic problem:

I have two basic sharepoint lists:

Person (list)
ID	Name
1	Person A
2	Person B
3	Person C

Fruit (list)
ID	Name
1	Apples
2	Pears
3	Bananas

I want to create a quantities form, for people to fill in easily, that has people's names that they can select as rows, and fruits as a column, IE:

	Pears	Bananas	+
Person A	5	10
Person B	15
+

The plus in the row or the column would allow them to add extra rows / columns from the lookup tables.

When saved, this enters into a third list, and the above example would create the following data:

Person	Fruit	Qty
1	2	5
1	3	10
2	2	15

Is this achievable in PowerApps (or forms?)

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

ChocDecor 9 on at

Like (0)

Report

Did you find a solution? I need exactly the same!

Was this reply helpful? Yes No
Florian_Kleinz 227 on at

Like (0)

Report

Hello,

I think creating a table to be filled in takes a little more effort.
You could easily implement a linear approach:

Please let me know if this is helpful.

Best regards

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

Were you able to figure out the solution for this? I have the same requirement. Please share if you were able to solve this.
@Anonymous @ChocDecor

Was this reply helpful? Yes No
JakobHansen 2 on at

Like (0)

Report

Has anyone made any progress with this ? This challenge is very general in nature, and an efficient solution will be useful under many scenarios 🙂

Was this reply helpful? Yes No