Unanswered

Sharepoint list look up value and sum

(0) Share

Report

Posted on by vanzs

Hi there, I'm seeking for some help about Sharepoint list.

I have two columns in a Sharepoint list, one column (Named Operation) get data when a new response is submitted in Forms, and another column (Named Time) is based on Operation column another list, there is an example:

A list stored data that Time column to look up

Item	Time2 (min)
A	10
B	15
C	25
D	40
E	30

If Operation column get data ACD, the Time column will output 75 which is the sum of corresponding terms in item column (A-10, C-25,D-40, the sum is 75).

I have tried the Sharepoint lookup column but it doesn't seem to work the way I want it to. Is there any way to achieve this in Sharepoint List or Power Automate Flows?

Categories:

General topics

All responses (3)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Does your form allow users to choose multiple options, and do you want to calculate the total time corresponding to the selected options?
v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @vanzs ,
In my scenario, the 'Operation' list is not related to the 'Time' list. I do not use a 'lookup' type column. The 'Item' column and the 'Time(min)' column in my Operation list are single lines of text and numbers respectively type.
I did a test for your reference.
In my scenario:
replace(replace(replace(replace(outputs('Get_response_details')?['body'],']',''),'[',''),'"',''),',',decodeUriComponent('%0A'))
My SharePoint:
My MS Form:
Best Regards,
Sunshine Gu
vanzs 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Ghatak,

The answer of these two question is both yes.