web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Exporting an collectio...

Power Apps

Unanswered

Exporting an collection to an SQL database

(0) Share

Report

Report

Posted on by LouiseAspman

93

I've got a collection, which has multiple rows to it.

Is there a way to do it in canvas apps, or will I need to use a flow?

Thanks

Louise

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

RJM07 801 on at

Like (0)

Report

You should be able to do it using the ForAll() Function

Was this reply helpful? Yes No
LouiseAspman 93 on at

Like (0)

Report

@RJM07 thank you I will try that

Was this reply helpful? Yes No
timl 36,387 Super User 2025 Season 2 on at

Like (0)

Report
@LouiseAspman

Collect is the function that you would call to add multiple rows from a collection to a SQL Table.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect

Collect(YourSQLTable, YourCollection )

Depending on how your collection is setup, you may need to call ShowColumns/RenameColumns to ensure that the column names in your source collection match those in your SQL table.

Collect(YourSQLTable, ShowColumns(YourCollection, "Column1", "Column2", "etc" ) )

Was this reply helpful? Yes No

Join the conversation