web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Add multiple new rows ...

Power Apps

Unanswered

Add multiple new rows to datasource with predetermined values

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Have a powerapps page with a gallery, where I want to display 4 records at a time, depending on selected week.

This is fairly simple and easy, but I would like to have a button to the 4 records into a new week.
The columns I have is:

Type

Week

Value

The user must insert a new value into every row in the gallery, but I would like to add the 4 different types automatically by the use of a button.

For now my button looks like this:

Patch(
 Table1,
 Defaults(Table1),
 {
 Type: "A",
 Week: "16",
 },
 {
 Type: "B",
 Week: "16",
 }
)

However this will only add the last values I have and not both into two new rows.

Any tips on how to solve this?

Thanks!

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Change your formula to the following:

Collect(Table1, Table( {Type: "A", Week: "16"}, {Type: "B", Week: "16"} ) )

This will create two new records with the record values provided.

I hope this is helpful for you.

Join the conversation