ClearCollect onstart doesnt work??

[RK]

SImply that, why cant I do a clearcollect onstart?

[v-micsh-msft · Accepted solution]

Hi @RK,

I just tested the OnStart property with the clearcollect function, and it works from my side.

To have this property work, you need to first save this App and then open it to trigger the Clearcollect formula under the OnStart property.

For more information about this property, please check:

Screen control in PowerApps

Regards,

Michael

[BM123]

Yeah, this solution did not work for me either. Im working with 80-100 imported Excel tables from the 365 User Platform. I know a SharePoint list would be a better solution but it would be nice to understand more of what the limitations are when using the Excel tables import option. Thank you for posting though. 

[Drrickryp]

Hi @BM123,

@Meneghino has a blog called powerapps 101 and he has a post that talks about some of the different connectors, their advantages and disadvantages.  https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/ .  It may answer some of your questions and help with app development in the future.