cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SinLeeNg
Frequent Visitor

In a new collection, how to create a column with a space in its column name?

Hello everyone,

 

I would like to ask how do I create a new collection with a space in one of its column name, say "Start Date"?

Collect(newCollectionName, {

    "Start Date": dateValue1 & " " & minuteValue1 & " " secondValue1

});

 

Thank you all!

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @SinLeeNg ,

You just need single quotes and ClearCollect if this is new

ClearCollect(
   newCollectionName,
   {'Start Date': dateValue1 & " " & minuteValue1 & " " secondValue1}
);

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

 

View solution in original post

5 REPLIES 5
Ramole
Super User
Super User

Hi @SinLeeNg 

This how to create collection 

Collect(
    ProductList,
    {
        Product: ProductName.Text,
        Color: Colors.Selected.Value
    }
)

Create and update a collection in a canvas app 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.
WarrenBelz
Super User
Super User

Hi @SinLeeNg ,

You just need single quotes and ClearCollect if this is new

ClearCollect(
   newCollectionName,
   {'Start Date': dateValue1 & " " & minuteValue1 & " " secondValue1}
);

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

 

Ramole
Super User
Super User

@SinLeeNg 
If you want to learn collection into depth download this sample app from @mdevaney also visit his blog you find lot of useful scenarios 
Collections Cookbook: 50+ Visual Examples & Code 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

@Ramole ,

The question was how do I create a new collection with a space in one of its column name, say "Start Date" - it is much better to supply the correct code than links to general collection articles

@WarrenBelz 
You've already supplied the correct code, if @SinLeeNg needs to learn more about collection I have supplied a sample App for reference that may help @SinLeeNg, by the way Collections Cookbook: 50+ Visual Examples & Code exactly what everyone will come across and thanks to @mdevaney,
Supplying a sample app will not harm.
I hope that answers your question. 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,216)