cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Corissandageri
Level: Powered On

Collection from a gallery and a date picker at once

Hi all

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

 

Thank you

2 ACCEPTED SOLUTIONS

Accepted Solutions
Dual Super User
Dual Super User

Re: Collection from a gallery and a date picker at once

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!

View solution in original post

Corissandageri
Level: Powered On

Re: Collection from a gallery and a date picker at once

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.

 

View solution in original post

11 REPLIES 11
Highlighted
PavanKumar
Level 8

Re: Collection from a gallery and a date picker at once

Could you please elaborate the question?
dynamicsedge
Level 8

Re: Collection from a gallery and a date picker at once

@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
Level: Powered On

Re: Collection from a gallery and a date picker at once

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.

dynamicsedge
Level 8

Re: Collection from a gallery and a date picker at once

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

Dual Super User
Dual Super User

Re: Collection from a gallery and a date picker at once

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
Level: Powered On

Re: Collection from a gallery and a date picker at once

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

dynamicsedge
Level 8

Re: Collection from a gallery and a date picker at once


@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
Level: Powered On

Re: Collection from a gallery and a date picker at once

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.Screenshot 2020-01-20 16.26.03b.pngScreenshot 2020-01-20 16.26.23b.png

 

Screenshot 2020-01-20 16.27.07b.png

Dual Super User
Dual Super User

Re: Collection from a gallery and a date picker at once

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!

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,252)