web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Sum

Power Automate

Answered

Sum

(0) Share

Report

Report

Posted on by GhassSD

141

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.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
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 !

Was this reply helpful? Yes No

Join the conversation