Answered

Canvas App: Multiple rows of the same SharePoint List columns?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Whats the best way to enable an end user to populate several columns of a SharePoint List multiple times in one Power App screen?

I'm looking to replace a Word document that contained a table with several columns and multiple rows. My only solution to date is creating multiple duplicates of the SP List columns but I know there's probably a neater solution.

Ideally I'd like each new row in the app to be duplicated as a new row in the SP List.

Thanks

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

can you perhaps put together an image showing what you would like it to look like, and how each part relates to your splist etc? the verbal description isn't 100% clear and I think that's probably why there have been no responses
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @TheRobRush

User would type in the three row 1 ‘column’ text boxes ‘A,B and C’. The content of these boxes would then be migrated to corresponding SharePoint List columns. The same would happen if they filled in row 2, 3, 4 and 5. These rows would be connected via the same reference number.
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

thats pretty much always how updating a sharepoint record via a gallery will work in powerapps, each row of a gallery refers to the source set in the gallerys items and updates the various columns connected to thisitem.column name. Is the question how to edit pre-existing records via this gallery and submit all changes simultaneously (and will this be via a save button etc) or how to add new rows alll simultaneously form filled in info etc? Will it always be only 5 records, whats the gallerys items look like (if diff from your splist name and why its diff etc)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @TheRobRush
It would be to add new rows simultaneously to a SharePoint List via a canvas app form.
The maximum number of rows (records?) would be 15.
I've not yet used gallery for this solution. The SharePoint List column titles would be the same as in the image.

Thanks again.
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Ok so here is an example.

For this example I have made a gallery called gallery29, it has a items property of

Sequence(15)

It has 3 text inputs inside of it that I named Column A, Column B, and Column C

Outside of it I have placed a button with the onselect

Patch(TestColumns, ForAll(Gallery29.AllItems As GallAdd, If(Or( !IsBlank(GallAdd.'Column A'.Text), !IsBlank(GallAdd.'Column B'.Text), !IsBlank(GallAdd.'Column C'.Text)), { Title:"Random Text", 'Column A':GallAdd.'Column A'.Text, 'Column B':GallAdd.'Column B'.Text, 'Column C':GallAdd.'Column C'.Text } ) ) )

This goes through the galleries 15 rows of 3 columns and any row that contains data it patches that into our splist TestColumns.

It patches the 3 columns, and also in the example a title column (title column is always required so if one of the 3 columsn IS designated as your title column then ignore that add, otherwise you will need to decide what to patch in for that column as well)