Collect formula error

[MikeBlairTP]

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.

[4th8]

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

[MikeBlairTP]

[4th8]

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.

[v-qiaqi-msft · Accepted solution]

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
)

[MikeBlairTP]

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

[v-qiaqi-msft]

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

[MikeBlairTP]

Hi @v-qiaqi-msft