ClearCollect a SQL View

[tlawsonpinewalk]

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.

[tlawsonpinewalk · Accepted solution]

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...

[seadude]

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]

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?

[seadude]

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?