cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tlawsonpinewalk
Level: Powered On

ClearCollect a SQL View

When editting my PowerApp I am able to perform a clearcollect on a sql view to store the information for cases where the user wants to add a new record to a subsequent table.

On publishing it appears that the clearcollect feature no longer works, my collection is blank.  I know that SQL views are currently read-only but does this include populating a collection, and is it the case that there would be a difference between edit mode and published mode.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
tlawsonpinewalk
Level: Powered On

Re: ClearCollect a SQL View

I resolved this - it appears that the issue was around the explicit column selection setting - once I turned that off my collection populated correctly as expected.

 

I got my clue from here

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/ClearCollect-and-Filter-working-in-weba...

View solution in original post

5 REPLIES 5
Highlighted
tlawsonpinewalk
Level: Powered On

Re: ClearCollect a SQL View

I resolved this - it appears that the issue was around the explicit column selection setting - once I turned that off my collection populated correctly as expected.

 

I got my clue from here

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/ClearCollect-and-Filter-working-in-weba...

View solution in original post

Super User
Super User

Re: ClearCollect a SQL View

I'm having this exact same problem: Unable to consistently ClearCollect a SQL View on mobile device ONLY. Works fine in IDE Preview Mode and Browser Player. Unfortunately, turning off Explicit Column Selection DID NOT HELP. How can I debug and fix this? This app is late due to this issue.

Thank you

t19670
Level: Powered On

Re: ClearCollect a SQL View

I have exactly the same problem. I ClearCollect data from filtered sql table and it does not return all the data, i.e the last record saved to the sql table. (and yes the record is saved and i can see it in sql table)

 

Turning off Explict Column Selection does not help me either. 

 

Strange thing is when I repeat the ClearCollect again a few minutes later the last record is returned from the sql table.

 

Has anyone found a fix yet?

Super User
Super User

Re: ClearCollect a SQL View

Hi @t19670 , I think I ended up doing a Refresh() on BOTH the View and its associated tables after submitting record to get the latest change to appear. Have you tried this?

jbentley
Level: Powered On

Re: ClearCollect a SQL View

grrrr..... spent 6 hours trying to sort out why the data in some fields wasn't showing up in a collection when performing a clearcollect against an SQL table.  finally came across this post.  turning off the explicit column feature and the issue went away.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,899)