Sum

[GhassSD]

Dears,

I have 2 SharePoint lists.

First One: 'ProductsTime' : each product have a time(number column). eg 1 hour for Powerapps product 1 hour for Power automate...

Second List: 'Request' I Lookup the Product column(accept multiple choice value) from 1st list to second with time column.

I Create an app: that submit the form of the 2de list in order to add new record.

As shown above the product column is in a datacardvalue dropdown that accept multiple choice.

My target is to count or calculate the time according to selected product in dropdown.

if user choose power apps & power automate so the time is 2h

If user choose just power apps so the time is equal to 1h.

Any idea

Thanks.

[gabibalaban]

Hi @GhassSD ,

I think that this problem is solved on PowerAutomate community forum.

https://powerusers.microsoft.com/t5/General-Power-Automate/Sum/m-p/810466#M64389

[rahulswimmer]

@GhassSD 
I have managed to achieve what you want.
Disclaimer: There has to be a better way to do this. This one is a little cumbersome.

I created a Product table i excel to simulate your sharepoint list. It looks something like this:

Then I created a combox with Items property as 

Items: Table1.Product

And now my combox looks something like this:

Now starts the dirty work. Pay attention. 
In the OnChange event of the combox I have included the following code:

// Bring all the selected items in a string (comma separated) using the concat function
Concat(
    ComboBox1.SelectedItems,
    Product,
    ","
);

// Use the split function to break the string and bring it in a table form
ClearCollect(
    colProducts,
    Split(
        Label1.Text,
        ","
    )
);

 At this point a collection called colProducts is created and looks like this:

So, now a part of the problem has been solved: By bringing the selected items in table form.
Note: Name of the column in colProducts is assigned by PowerApps i.e. Result .

Add the following code to the same onchange event of combox:

// Create a collection with blank object called colProductNew
ClearCollect(
    colProductNew,
    {}
);

// Clear it, so that fresh values can be added.
Clear(colProductNew);

// Loop through the colProducts collection and add a field Time in the new collection using the Lookup function.
ForAll(
    colProducts,
    Collect(
        colProductNew,
        {
            Product: Result,
            Time: LookUp(
                Table1,
                Product = Result,
                Time
            )
        }
    )
);

In collection colProducts, we are missing the Time value for each product, hence I created a new collection and used Lookup functionality to fetch their time values from the source table. Now the new collection looks like this:

Create a label to test the last bit i.e.

Sum(colProductNew,Value(Time))

App functions like this:

[GhassSD · Accepted solution]

Dears,

Thank you guys @gabibalaban  & @rahulswimmer four your help.

Issue was solved yesterday by @gabibalaban 

I will try this new method also.

Thank You.

[GhassSD]

Dears @rahulswimmer,

I tried your solution, it works fine for a combobox outside of an edit form. But in my case i have  the combobox inside an edit form and i need to achieve your solution in the same page of my form as live time estimation(fresh value). 

The solution of @gabibalaban give me the time estimation after sumbitting the form on other page. 

Any solution to achive the live calculation in the same edit form page?

Thanks guys