Unanswered

Auto generate the default value for a field in a gallery and patch this to a collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a collection called 'ItemCollection' with fields like itemid, ItemLabourTime (this is the time required to manufacture an item), Labour(i.e TotalLabour, based on quantity entered) and several other fields.
I'm trying to read in the value for quantity from the user in a gallery(see screenshot below) and auto-generate the field Labour based on the value entered by the user.

So if a item has ItemLabourTime of 10 mins and the user enters 2 for quantity, the labour value (i.e TotalLabour) for that item in the gallery should be 20.
I was trying to use the following formula to patch a default value for Labour to the collection -
Patch(ItemCollection, ThisItem,{Labour: ThisItem.ItemLabourTime*ThisItem.quantity})
but that was giving me an error- 'behavior function in a non behavior property'.

The plan was to set this as default and use an update in the Onchange value if the user wants to reset the auto generated value.

How can I achieve this functionality? Any help is much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try

Patch( ItemCollection, ThisItem, {Labour: Value(ItemLabourTime.Text)*ThisItem.quantity} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry, that's not working. Still giving the same error.

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Where are you running the code from? To use ThisItem it must be from within the gallery. I also assume ItemLabelTime is the Text box.

Was this reply helpful? Yes No
BoHamad on at

Like (0)

Report
Copy link

Link copied!

For labour text box in the Text property
use this formula Value(ThisItem.quantity)*Value(ThisItem.ItemLabourTime)
But, to patch the values to the collection I recommend to add a button to save the data for all gallery or for a single record. Because it doesn’t make sense if u want to patch the values every time when the user change the value

hope this helps u

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Yes I'm using it within the gallery.
ItemLabelTime is not the text box, it is the predefined time required per item. The user enters the quantity and the app should generate the highlighted "Labour"(TotalLabour) field. i.e Quantity * ItemLabelTime(for that item in the gallery)
The only reason I have the input box (text box) is to read in any changes to the automatically calculated time.

Btw, appreciate you looking into this!

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

If ItemLabelTime is not a control, I assume it is a field in your source data List - what type of field is it?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, it is a field in my source. My source is a SharePoint list and ItemLabelTime is of type number.

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Anonymous ,

Only one thing left then - the quantity is entered by the user?

Patch( ItemCollection, ThisItem, {Labour: ThisItem.ItemLabourTime * Value(QuantityTextBoxName.Text)} )

Replace with your text box name

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Unfortunately still returning the same error!

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous ,

At this point, it is not making a lot of sense as this is the most basic of Patches referring to two items that if numeric should simply work. Put two labels in your gallery with the following

ThisItem.ItemLabourTime

and (whatever the text box name)

Value(QuantityTextBoxName.Text)

Do you see numbers in both ?

Was this reply helpful? Yes No