web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Creating a collection ...

Power Apps

Answered

Creating a collection from a SQL view

(0) Share

Report

Report

Posted on by coder57

16

Hi
I am trying to create a collection from a SQL view. Is this possible

So far I have tried

ClearCollect(colQC13List,'[GFX_Sales].[DC_QC13_DataView]');

With the explicit column selection setting turn off as per https://powerusers.microsoft.com/t5/Expressions-and-Formulas/ClearCollect-and-Filter-working-in-weba... View solution in original post
I have also tried putting a unique row number in the SQL view

and finally I tried the the

ShowColumns() method

So far nothing is working

I am aware I could had build the collection with various lookup and add columns method but the view cross four SQL tables, so it would be a bit of a pain....

Could some let me know if I can set up a collection from a SQL in powerapps (It would seem a sensible thing to want to do)

If the answer is no, what have other done as a work around

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

timl 37,285 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@coder57

Yes, this is possible. In my example here, vw_DistinctCities is a SQL Server view.

This formula collects the view as expected.

What is it that doesn't work for you? Is it that colQC13List doesn't contain any data, or you seeing an error message?

As a first step, I would try removing the view from Power Apps and re-adding it. If that doesn't work, I would run Monitor and check that Power Apps is making the call to SQL Server.

Was this reply helpful? Yes No

Join the conversation