Collection from a gallery and a date picker at once

[Corissandageri]

Hi all

Is it possible to clearcollect from a gallery and from a separate date picker to one collection?

Thank you

[PavanKumar]

Could you please elaborate the question?

[poweractivate]

@Corissandageri 

Yes, you can simply define your column with ClearCollect and as one of the columns use the Date Picker value, and for the other columns use your gallery (e.g. Gallery.Selected) stuff.

As @PavanKumar  a further explanation of your scenario may help.

[Corissandageri]

I'm not sure if it's the best way, but in my gallery, I have a label that is referenced to my date picker. so when I patch my gallery, it includes the date. Thanks for your replies.

[poweractivate]

@Corissandageri 

Unsure, but you should probably convert the Text to Date (using DateValue function).

However - if your Data Source is expecting a string or text value, then you should just directly Patch the Text value from your Label - otherwise, you would want to convert the Text to a Date with this way:

DateValue(YourLabelControl.Text)

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

DateValue, TimeValue, and DateTimeValue functions in Power Apps

Converts a date, a time, or both in a string to a date/time value.

Description

The DateValue function converts a date string (for example, "10/01/2014") to a date/time value.

The TimeValue function converts a time string (for example, "12:15 PM") to a date/time value.

The DateTimeValue functions converts a date and time string (for example, "January 10, 2013 12:13 AM") to a date/time value.

The DateValue function ignores any time information in the date string, and the TimeValue function ignores any date information in the time string.

[yashag2255]

Hey @Corissandageri 

Do you intend to patch all the items in the gallery along with the datepicker as a field? If so, you can pass the parameter like:

I am assuming that the datepicker is outside the gallery control.

expression:

ForAll(Gallery1.AllItems,Patch(DataSource,Defaults(DataSource),{Col1:GalleryColumnName, DateCol: DatePicker1.SelectedDate}))

This will it will reference the field directly.

In case of a collection:

ClearCollect(CollectionName, AddColumns(DataSource, "DateColumn", DatePicker1.SelectedDate))

This will add all the rows from datasource to collection and add a column for the date which will be filled by the datepicker.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Corissandageri]

Thank you I see I have a few problems I need to sort out.

[poweractivate]

---

@Corissandageri wrote:

Thank you I see I have a few problems I need to sort out.

---

@Corissandageri 

Unless you have a specific reason it needs to be a string, it may be better not to put the Date Picker value into a Label - it introduces more indirection. If it needs to be a text value, even then you don't need Label - you can use this function:

Text(YourDateHere)

[Corissandageri]

Well I'll do my best to be clear, I have the first part of the app which produces an order that gets emailed, and I can also patch to table4 (same as Sheet4) But the part I am working on now is the receiving of the stock. which then gets patched into that same Table4 Excel sheet. That's why there are two date columns, one from when the order was created and one when for when I receive stock. So I think this one of the reasons I'm getting stuck, trying to patch an existing record but then adding new data.

Thank you.

[yashag2255 · Accepted solution]

Hi @Corissandageri 

Thank you for sharing the detailed information. I understand that you want to show the Date received inside the gallery but it is not necessary that you reference the same in the ForAll loop. As the date received is set to today and cannot be changed. Can you try to update your expression to:

ForAll(ReceiveList, Patch(Table4,Gallery5.Selected,{QuantityRO:TextInputReceived.Text, DateRO: Today()}))

Also, I wanted to check on a few things here, what does the Receivelist collection store? Based on what I see here, even though you are applying a loop here, it is always going to patch on the gallery selected record. Have you passed any other field apart from the two mentioned here, which is getting its value from the ReceiveList?

Also, if you wish to reset the gallery, that can be done using Refresh(Table4) as Reset() function does not work on gallery controls.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!