web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Send multiple rows fro...

Power Apps

Answered

Send multiple rows from gallery to a collection upon submit

(0) Share

Report

Report

Posted on by msuser48

28

Hi,

I want to send all items/images from a Gallery to a collection in one click. My approach:

Output: When I click "Collect", only the first item/row in the Gallery is sent to the collection.

Question: How can I send all items/rows (a total of 3 images) from the Gallery to my collection when clicking "collect"?

Only items visible in the "attachments" box should be sent to the collection, of course.

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@msuser48

Please consider changing your Formula to the following:

Collect(colImages, ForAll(ImageGallery.AllItems, {image_name: ImageTitle, image_blob: ActualImage } ) )

I hope this is helpful for you.
msuser48 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayesthis part definitely worked - thanks!

However, when I click a "Submit" button with OnSelect propery as "Collect(table1, colImages)", it sends all data from this collection to the SQL Server's table1 - regardless of whether the data already exists in that table.

How do I ensure that when I click "Submit", it only sends records to the SQL server, which do not already exist in table1 (image_name is what must not already exist in table1)?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@msuser48

Yes, the formula only will create records as it is. In order to restrict, it needs to have logic in it to exclude certain existing records.

Is that part of all your other posts?

Join the conversation