Collect Function

[PowerAppsNoob1]

Hi all

I'm sure someone will have a quick answer 🙂
I'm scratching my head at the moment and can't work out why I are getting the error.

I have the following code, however its giving me an error and I cant work out why!
It broke when I added the additional table Item "Time"

Collect(TimeEstimate, {Item:Label1_1.Text, Time:Label2.Text}) ; Navigate(NetworkScreen)

Thanks

[KrishnaV · Accepted solution]

Hi @PowerAppsNoob1 ,

Time is a keyword try the same as below:

Collect(TimeEstimate, {Item:Label1_1.Text, TimeVal:text(Label2.Text)}) ; Navigate(NetworkScreen)

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[PowerAppsNoob1]

Thank you for your help, you may be able to help me with another quick one, 

I am trying to add up the TimeVal collection total into a text label.

Any idea's? - Basically I am after a total time box once all items have been added to the collection and show in the gallery.

[KrishnaV]

Hi @PowerAppsNoob1 ,

try this:

updateContext({varsumvalue:Sum(collectioname,TimeVal)})

Now set the varsumvalue to a label.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[PowerAppsNoob1]

Hi @KrishnaV 

Thankyou for your reply, but where am I entered the code 

updateContext({varsumvalue:Sum(collectioname,TimeVal)})

If I entered it on the textLabel I just get an error? 

[PowerAppsNoob1 · Accepted solution]

I have solved it with this line of code 🙂

Sum(TimeEstimate, TimeVal)

[Tapesh]

Hi @KrishnaV  and @PowerAppsNoob1  is there a way to sort the collection using the sort function in ascending order?

please find the code below, 

ForAll( 
    Gallery4.AllItems,
    Collect( 
        ExportColGal4, 
        {
           
            Column1: Text(Gal4ACustId.Text),
            Column2: "I",
            Column3: 501,
            Column4: 10, 
            Column5: 2020,
            Column6: "",
            Column7: Gal4Description.Text,
            Column8: Gal4Created.Text,//should be in format of dd-mm-yyyy
            Column9: Gal4GLcode.Text,//this should be the GL code
            Column10: ""
}
)
)

Thanks in advance for the help. 

[KrishnaV]

Hi @Tapesh ,

This is a closed thread I would advise you to open a new thread to help you better.