cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GhassSD
Advocate II
Advocate II

Sum

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_6-1611927222019.png

 

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

GhassSD_7-1611927294036.png

 

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

 

GhassSD_8-1611927374171.png

 

GhassSD_10-1611927458887.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.

2 REPLIES 2
zmorek
Super User
Super User

I avoid Lookup columns when I can, because they're hard to work with; in this case, I'm not sure they're entirely needed.

If(And(!IsBlank(LevelOfFocusDataCardValue.Text), Or(LevelOfFocusDataCardValue.Text = "Power Apps", LevelOfFocusDataCardValue.Text = "Power Automate"), 1, 2) 

 

That should check if the Data Card's value is blank, and if not, if the value is either Power Apps or Power Automate, return 1, else return 2.

Dear @Zmor  thank you for your reply,

 

i wan to sum the product hours.

e.g.: power apps take 1 hour

power automate take 1.5h

Power Virtual agent take 2h

SharePoint 3h

 

if the user choose power app& SharePoint the result is 4h

if user choose power automate & Powerapp the result is 2.5 h

 

in my case maybe i have more than 20 products.

i want a method that count the sum of products hours according to the user selection.

 

Thank you in advance

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,503)