Unanswered

Frustrating LoadData Error

(0) Share

Report

Posted on by testtest123test

Hello,

I have an app that works offline and has been working for a long time now and now I wanted to make a few edits and as part of that, I wanted to load the data from the data saved in the phone into a new collection and I was calling it coltempdata as shown below. This code is what runs on app start and I get this frustrating error that says "The function "clear" has some invalid arguments" and "The function "LoadData" has some invalid arguments" which makes zero sense as there is another LoadData command right under this that works with no issues.

I also see this error sporadically "Collection has an empty schema. No columns will be accessible after this operation. Consider using an existing collection or writable data source with a known schema instead."

I am scratching my head for 2 days why I am getting this error and tried multiple things such as initializing a blank collect with

a ClearCollect(colfullsurveytemp,Blank()); statement which them Powerapps somehow likes and stops throwing the error on LoadData. I have never initialized blank collections like this ever.

Any one has any idea why PowerApps is angry on my loaddata into a new collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Kosenurm 802 on at

Like (0)

Report
Copy link

Link copied!

@testtest123test

coltempdata is not a valid collection. Have you already created this collection and then made changes to the code? If so, when you are creating coltempdata collection, it already exists so can't create it again.

If so, go to File > Collections and delete the coltempdata in there. Then your code should not have an error.

Was this reply helpful? Yes No
testtest123test 39 on at

Like (0)

Report
Copy link

Link copied!

@Kosenurm , coltempdata wasn't created before. The code in the image is the first few lines of On App Start. I didnt follow what you meant by hve you already created thus collection? Isn't the collectionn supposed to be created when LoadData runs? The collectionn colpic is being loaded using loaddata function and I dont have it explicity created anywhere in the app.

Also, deleting the coltempdata collection from File > Collections, I donn't see any delete option. Can you guide me?

Was this reply helpful? Yes No
Kosenurm 802 on at

Like (0)

Report
Copy link

Link copied!

@testtest123test
It is errorring as coltempdata is not referencing correctly. Where is this variable which you create OnLoad used in your app?

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@testtest123test

Try this by Shane will help how is done https://www.youtube.com/watch?v=NwbqdA9j8Ek

Was this reply helpful? Yes No
testtest123test 39 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ramole ,

Thanks for the video pointer. This is great for getting started with offline capability and this is where I started 1.5 years ago.

The error I am getting is more specific though. Never seen this happen before. Any idea what it's trying to tell?

Was this reply helpful? Yes No
testtest123test 39 on at

Like (0)

Report
Copy link

Link copied!

@Kosenurm

I am using the collection in app start like this:
If(CountRows(colpic)> 0,
RemoveIf(
RenameColumns(
coldata,
"PrimaryID",
"PID"),PID in
Filter(coltempdata,Status = "Complete").PrimaryID)
);

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @testtest123test :

The Point is that he collection named "coltempdata" do not exist.

There must be a definition statement about this collection in your App, for example:

ClearCollect(coltempdata,[1,2,3])

Before

After I add an other button and set it's OnSelect proerpty to:

ClearCollect(coltempdata,[1,2,3]);SaveData(coltempdata,"saversults")

The error disappeared.

Best Regards,

bof

Was this reply helpful? Yes No