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 in the list.

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.

[GhassSD]

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 in the list.

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.

[zmorek]

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.

[GhassSD]

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