Unanswered

Patching table with two galleries

(0) Share

Report

Posted on by nekinekic

I have a data table that has columns Name, Task, Days

Name	Task	Days
Jon	Take out laundry	2
Jon	Clean dishes	3
Bob	Take out laundry	4
Bob	Clean dishes	6

I would like to create a gallery(ies) that can input the data like below. Where if you add a new task with the click of one button it automatically creates two input fields for days for both Names. I am not sure if this is even possible with multiple galleries and one button for Patching a table. Any help in the right direction would be greatly appreciated.

Task	Jon	Bob
Take out laundry	2	4
Clean dishes	3	6
<Input New task>	<Input Days>	<Input Days>

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 154,393 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @nekinekic ,

This will get you the data you want, but not the format as you cannot dynamically name fields in Power Apps.

AddColumns( GroupBy( YourTableName, "Tasks", "Name", "OtherData" ), "NoTasks", CountRows(OtherData) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
proxyprochy 92 on at

Like (1)

Report
Copy link

Link copied!

The previous answer seem to be working.

also, if you want to display those in a nice way, I found this video .

Was this reply helpful? Yes No
nekinekic 20 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the responses. Just to clarify I did not want to create any new fields. I wanted to arrange the galleries in a such a way so that the data can be collected in the permuted way, but the table fields remain the same.

Was this reply helpful? Yes No
WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nekinekic ,

I understand what you want, but it is simply not possible to do in Power Apps for two reasons. Firstly, you cannot dynamically create column names - there may be a complex (sort of) workaround using nested galleries, but I am sure that is not what you are after. Secondly, the moment you use Distinct or GroupBy, only one column is returned, so you have to add the others back in.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No