Collection from a gallery and a date picker at once

(1) Share

Report

Posted on by R Bakker

725

Hi all

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

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

PavanKumar 479 on at

Like (0)

Report

Could you please elaborate the question?

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
R Bakker 725 on at

Like (1)

Report

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

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
@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)

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Verified answer

R Bakker 725 on at

Like (0)

Report

Hi
I was having trouble making it patch both the date and the quantity. In the end I put the expression in the text input itself to patch OnChange
Patch(Table4,ThisItem,{QuantityRO:TextInputReceived.Text, DateRO: Today()});Refresh(Table4)
Thank you for the auto date and Refresh, all I need now is a way of hiding the order number when the total order has been received.

Was this reply helpful? Yes No