Unanswered

Add Text boxes inside a column when clicking a button.

(0) Share

Report

Posted on by KuroWani

Hi,

I'm new to PowerApps and I'm trying to implement a new function to a Sharepoint list, but I don't know if this is possible or even the most appropriate way.

When a user has multiple packages with different dimensions, I want to give him the ability to add new rows inside a column, like show in the example bellow. I also want the option to delete the added new rows.

I tried some methods I found in this forum and other websites, but I wasn't able to make this work.

There are some key points regarding this implementation. Currently, when a new item is created in a Sharepoint list, through Power Automate, an Excel template sheet is copied, renamed and the corresponding cells are automatically filled with the data from each column. But since I would be creating fields inside a column, is there a way to properly separate this data so it can be used to fill individual cells in a Excel sheet? Because I believe in a case where there are 3 different packages, it would fill all 3 numbers inside the same cell, so maybe my idea isn't ideal for my goal.

I hope I was able to properly explain my needs. I would be very thankful if someone could help me to solve this problem.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

QuantmResonator 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KuroWani,

You can use the Patch() function to fill individual cells of an excel table through power apps.

The excel table must be added to power apps as a data source so this may not work with your current method of duplicating sheets.

You could also Patch records on an existing Sharepoint list, and add functionality for your flow to respond when an item is modified.

Was this reply helpful? Yes No
KuroWani 9 on at

Like
a
(0)

Report
Copy link

Link copied!

@QuantmResonator
Thank you for the idea.
I maybe have a workaround regarding the Excel part, but the add new rows function is essential.

Is it possible that instead of creating new rows inside those columns, I put a button that would move the user to another screen, where's there's a gallery or something that allows the user to fill several fields as needed?
So once they fill the data and submit, they go back to the previous screen and then all the input data fills the respective columns in the main page, if I can do that while creating a delimiter between the text from each text field, I can filter this information later through other means.

Was this reply helpful? Yes No