ClearCollect function tags my collection as "Invalid Argument Type"

(0) Share

Report

Posted on by awalker

233

My powerapp broke last week. One of my collections won't collect data from a sharepoint list anymore.

Here is the formula:

ClearCollect(colWellnessLogAvailableOptions, WellnessLogAvailableOptions);
ClearCollect(colWellnessLog, Filter(WellnessLog, Name1 = varUser.FullName));

The first collection works, the second, "ClearCollect(colWellnessLog, Filter(WellnessLog, Name1 = varUser.FullName));" will not.

When I hold my cursor over "colWellnessLog" the error reads:

"The function 'ClearCollect' has some invalid arguments. Invalid argument type."

Oddly enough, when I change the collection "colWellnessLog" to something slightly different, (e.g. "colWellnessLogs") it will work.

Powerapps doesn't seem to like that name. Could it be because it's duplicating a section of another collection's name?

This function has worked for well over a year now and just recently stopped working.

Any ideas?

Error 1.PNG Error 2.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@awalker

What kind of column is Name1 in your list?? If it is a person column, then change your formula to the following:

ClearCollect(colWellnessLog, Filter(WellnessLog, Name1.DisplayName = varUser.FullName));

I hope this is helpful for you.

Was this reply helpful? Yes No
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

Name1 is a single line of text column.
Today the original function
ClearCollect(colWellnessLogAvailableOptions, WellnessLogAvailableOptions);
ClearCollect(colWellnessLog, Filter(WellnessLog, Name1 = varUser.FullName));
works again without errors. But now several other functions have errors that worked when I posted this originally - and I have made no changes to the app.

Now this function and others like it have errors:
Patch(MileageLog, colMileageLog);
Error Message:
"Invalid argument type (Table). Expecting a record value instead."

And:
"Collect(colWellnessLog, WellnessLog)"
Error Message:
"Incompatible type. The collection can't contain values of this type"

I've come across these types of things before - functions displaying errors after working properly for extended periods of time.
Would you have any idea why this might be occurring?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@awalker

The issue is that when you edit an app, if you make any kind of schema changes along the way, the formula editor will remember those changes as you edit. In other words, if you have a formula that creates a column in a collection and then you remove that function during the editing, the formula editor still has inferred that the column is there and other functions will not trigger an error. Once you close and reopen the app, it then re-infers the schemas and once "remembered" columns no longer exist and then formulas have errors.

For your Patch function, that is a misleading error - it is really saying "you have columns in your collection that do not match the schema of the datasource" When you use a patch like that, the schema of the collection must match exactly the schema of the datasource.

Was this reply helpful? Yes No
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah. Details. How do I fix this problem? And - how do I clear any hold-overs like this in the future? Is there a function?

Greetings

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@awalker

Well, for the Patch function, you need to look at everything about your collection...names of columns, types of columns, etc. They must match identically. Column names must match the real column names in the datasource. Complex columns must have the exact required schema for their records as well. Also, any added columns are not allowed.

So, you're kind of showing your starting point (where you collect the data) and the ending point (where you patch the collection to the source), but what happens in between to the collection? If you are interacting with it in the app, what are you changing?

Those are all things to investigate.

Was this reply helpful? Yes No
awalker 233 on at

Like
a
(1)

Report
Copy link

Link copied!

I see. Thank you - this is very helpful

Was this reply helpful? Yes No