Skip to main content

Notifications

Power Automate - General Discussion
Answered

Sum

(0) ShareShare
ReportReport
Posted on by 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...

 

GhassSD_0-1611918946222.png

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

GhassSD_1-1611919069415.png

 

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

 

GhassSD_4-1611919601432.png

 

GhassSD_3-1611919288387.png

 

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.

  • Verified answer
    CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 on at
    Re: Sum

    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 !

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard