Collect formula error

(0) Share

Report

Posted on by MikeBlairTP

149

This on select formula I am 100% sure that it has always worked but now has the dreaded red underline squiggle

Collect(
'Personal Account Dealing',
DataInput

)

Personal Account Dealing is the Sharepoint list I am writing to, it still exists and I have access to it. I've even removed it as a data source and re added it.

DataInput is the collection.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

4th8 on at

Like (0)

Report
Copy link

Link copied!

Any chance we can get a screen shot of the formula in question? Might help in figuring out what the issue is.

Was this reply helpful? Yes No
MikeBlairTP 149 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
4th8 on at

Like (0)

Report
Copy link

Link copied!

I agree that looks like it should work. Sometimes that can happen. Save and close then open the editor again. It should just go away.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MikeBlairTP,

Have you solved your problem?

Do you want to collect the 'Personal Account Dealing' into a collection named DataInput?

If the 'Personal Account Dealing' is indeed a SP list you write the data to, and the DataInput is indeed the collection you want to save the list data to, then I think your Collect() has something syntax wrong.

You should modify as below:

Collect( DataInput,//Here should be the collection name 'Personal Account Dealing' //Here should be the data source you want to save as a collection )

Was this reply helpful? Yes No
MikeBlairTP 149 on at

Like (0)

Report
Copy link

Link copied!

Correct @v-qiaqi-msft

Collection is called Datainput and the SP list is called Personal Account Dealing. I have copied your code on a new button and I still get the error

I have noticed some odd columns in my collection that I did not create

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MikeBlairTP，

Hover your mouse cursor over the red line to show me the specific error message.

Here is the doc about the Collect() function:

Collect, Clear, and ClearCollect functions in Power Apps - Power Apps | Microsoft Docs

Was this reply helpful? Yes No
MikeBlairTP 149 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

Was this reply helpful? Yes No