CODEWITHSUNDEEP
formssharepointsharepoint-onlinepowerapps
maicolo
maicolo

Reputation: 1

Repeating Section in Power Apps Does not load data when the user goes back to view the item

Im working on a power apps that grants the user the ability to enter data by row and add/remove rows as needed. Once the user has all the data enter, when they click save, it patches to the SharePoint List in a table format to a rich text column. The user sees this screen to enter data When the user gets to screen to add payments info and when it patches to the SP list, it writes like thispatches to sp list item with a table like formatting. When the user reviews the item details and information, it doesn't load the data.the repeating section loads nothing. The goal is to load the same data in the repeating section when the user goes to view the item in canvas apps.

For reference, I've used something similar to this solution to create what I currently have.

https://netwoven.com/sharepoint-custom-development/how-to-create-repeating-section-in-powerapps-and-save-data-to-sharepoint-list/

Note: I've seen solutions where you have a master list then child list with all the details. I want stray away from that solution. Reason being I want to avoid less maintenance and hitting threshold limit on sp list sooner.. However, I am open to any thoughts/ideas. Thank you in advance.

Upvotes: 0

Views: 396

Answers (2)

mmikesy90
mmikesy90

Reputation: 981

You could use the MatchAll() function to parse the HTML table in your PowerApps. This post can help you out with an example:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Converting-html-table-into-galley/td-p/1926838

Upvotes: 0

Sam Nseir
Sam Nseir

Reputation: 12111

The issue you have is that you are saving the data as an HTML table. Your repeating section cannot parse it back into items.

You should look to save the data as a JSON string to SharePoint as a Multiple lines of text and as Plain text column type. Then in your app, when you load in the item, you can use the ParseJSON function to turn it back into a collection. From this collection, your "repeating section" should be populated etc...

Upvotes: 0

Related Questions