Answered

Column name with {} in collection

(1) Share

Report

Posted on by baltenspda

Hello, I have a collection with a column named "{ContentType}", how can I insert this column into the "Collect()" function or ignore this column ?

I already test that : "{ContentType}", \{ContentType\} and '{ContentType}', but no one of this worked.

Thanks for all idea

Daniel

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi baltenspda,

When using the Collect() function, you should specify a data source that you want to add data to, then the records to add to the data source.

If you want to insert a column name “ContentType” to your data source, you could try to add a button and set its OnSelect property using the Collect function looks like below:
Collect(DataSourceName,{Name:”test”,ContentType:”AA”}).

For more details, please see this doc about Collect function for more details:
https://powerapps.microsoft.com/en-us/tutorials/function-clear-collect-clearcollect/

Please feel free reply if you need more help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
baltenspda 9 on at

Like
a
(0)

Report
Copy link

Link copied!

But, in your solution, the column name is "ContentType", in mine, the name is "{ContentType}", including the "{}", like the capture :
So, Collect(DataSourceName,{Name:”test”,ContentType:”AA”}) doesn't work because "ContentType" doesn't exist, but Collect(DataSourceName,{Name:”test”,{ContentType}:”AA”}) dowsn't work either because "{ContentType}" is not considered like a field.

This field was created when I transfer the data from SharePoint to the collection using SaveData() and LoadData().

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi baltenspda,

Please try to add a single quote on {ContentType}. The code would be looks like:
Collect(DataSourceName,{Name:"test",'{ContentType}':"AA"})

Hope this will work for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
baltenspda 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Tanks, it was working

Was this reply helpful? Yes No