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.
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 !