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 · Accepted solution]

Hi @GhassSD ,

To cleary understand, why don't you solve this from PowerApps ? Is there a particular reason to solve it with PowerAutomate (actually I don't think that is necessary to use PowerAutomate) ? In which column you want to save the result (I called it total_time)?  

From PowerApps:

   -   on submit button insert:     

  ForAll(
     ProductsComboBox.SelectedItems, 
     Collect(TimeCollection,
             LookUp(ProductsTime,Product=Value)
     )
)

   - in your form insert a datacard linked to the total_time column and set the Update property to:

Sum(TimeCollection,Value(Time))

Hope it helps !