Share
ReportHi all,
I'm looking for some help and/or thoughts as to the best approach would be for a PowerApp that I'm currently making, where people can raise a request.
The issue I'm having is on the products page. At the moment, the first row is made up of text inputs that can't be deleted (as there will always be at least one product with each request). However, I then have a gallery which is set to be a repeating table (the logic behind this is based off Shane Young's Youtube video). People can then use the repeating table to add more rows of products and have as many as they need and input the information.
In the background on this screen, I have a form that is set to invisible. On the top row (with the text input boxes), I then assign the text input of the product name to reflect "Product 0" on the form updates so when it saves back to sharepoint, the data is reflected in the "Product 0" column. I've also used a form instead of patching because the request is spread across multiple screens, and so it saves right at the end of the submission instead of throughout. However, I'm really stuck when it comes to assigning the rows to the other Sharepoint columns. I have an identifier on each row to display whether it's row 1, row 2, etc in the gallery. The ID changes dynamically if a row is deleted. My thinking behind this is to then say on the form for "Product 1", if it's row 1 in the gallery, then reflect this on the form update so it will update the "Product 1" column on Sharepoint.
It wouldn't be an issue if I was saving the data as rows, but because I need it all on the same row, but in different columns in Sharepoint, I seem to be struggling as to how I can patch or save the data back in this way?
Please see attached photos of both the PowerApp and sharepoint list for more information.
Has anyone come across a similar thing before and do you have any suggestions on how to go about it?
All responses (
Answers (
432
