Set a value from another table

[sajarac]

Good morning,

Quick question?

I have 2 Share point list, 1 is my order list and the other one is the products in order.

In my order lists I have a field Named = Total Products and basically I just manually populate the total of products for that order in my other list.

Now in that field I have changed to the following formula:

Total Product = Sum(Screen2.AllItems, TotalProducts)

Everything is fine I can get the total of my products the only thing that is bothering me is If I want to see the value of total products saved in my SPL "Orders" then I have to edit my form and save it. otherwise I see the value in the file but not in the list.

I think that setting that value "the total products" could resolve the issue?

And other thing sometimes takes longer for that field to show the value.

Could someone point me in the right direction?

thank you kindly. 

[WarrenBelz]

Hi @sajarac ,

If you are asking should you write the total back to the list, then yes, that is a good idea? Is this the issue?

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.

[sajarac]

Hi, sorry the question is wrong formulated.

My data card value that feeds the SLP Orders is getting the information from another table using: Sum(OrderGallery.AllItems, Quantity)

I can see the value from that gallery in my field but if fact if I want that value saved in my list Orders I have to put the form in Edit Mode then Save.

Will this action affect performance? I notice that it takes 1-2 seconds for the value to load the "sum". 

I thought I can set a variable but I have no idea.

Make sense?

Thank you kindly 

[WarrenBelz · Accepted solution]

Hi @sajarac ,

You can use Patch from a button - assuming your item is selected from another gallery

Patch(
   'SLP Orders'
   {ID:YourMainGallery.Selected.ID},
   {YourTotalField:Sum(OrderGallery.AllItems,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.