Merge dates from columns of a Sharepoint List in Combo Box

[ton_s]

Hi,

I'm trying to create events page. SP list as a data source. Each event will have three dates to choose from.

I have a Gallery with Combo Box and I want to merge dates from three colums of a SP list inside this Combo Box.

Is it possible?

Thanks in advance!

[RandyHayes]

@ton_s 

Can you explain what you mean by "combine"? (EDIT: sorry - I meant "Merge")

[Digital · Accepted solution]

Is the data source of your gallery the same SP list that has the three dates?

If so you could create a table from the dates in your SharePoint list and use that to populate the combobox

ComboBox.Items

Table(

{value: Text(ThisItem.Date1,"dd/mm/yyyy")},

{value: Text(ThisItem.Date2,"dd/mm/yyyy")},

{value: Text(ThisItem.Date3,"dd/mm/yyyy")}

)

[ton_s]

Thanks a lot!

[ton_s]

I mean group dates from three columns of SP in one ComboBox inside Gallery.

User "Digital" already solved this for me, but thanks for trying to help.

[RandyHayes · Accepted solution]

@ton_s 

No problem.

If you want to save yourself some typing, you can change that formula to:

[Text(ThisItem.Date1,"dd/mm/yyyy"), Text(ThisItem.Date2,"dd/mm/yyyy"), Text(ThisItem.Date3,"dd/mm/yyyy")]

This will produce a table with a Value column like you were suggested to do.  When using the square brackets in PowerApps, it will automatically do all the "Table" part and assigning the column name of Value for you.

[ton_s]

Thanks! This one is cleaner.