Extract values from list

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have the following from a multi select question on a form:

["Item 1 - £15.75","Item 4 - £16.94","Item 5 - £6.39","Item 7 - £12.00"]

I want to extract the £ values and then have the ability to add them up in a subsequent step.

Can any one assist?

Jon

All responses (8)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Extract values from list

Thanks Jay, all sorted now !

Cheers for your help.
Community Power Pla... on at

Like (0)

Report

Re: Extract values from list

Hi,

Thanks for your help so far, I have made the change to the compose action:

add(float(body('Get_response_details')?['rdcceec6ad947470a85506d8dca8ef8ed']),float(outputs('Compose_check')))

But still getting an error:
Verified answer

Jay-Encodian 2,920 on at

Like (1)

Report

Re: Extract values from list

@Anonymous
Having said that... it looks like your adding the output of the compose action with the value from the body (get response details).... this isn't correct.
You need to add the output of the compose action to the value of the 'Total' float variable... that way each time the for each processes an item in the array the 'Total' variable is incremented.
HTH
Jay
Jay-Encodian 2,920 on at

Like (1)

Report

Re: Extract values from list

Hey @Anonymous
You need to wrap the first parameter in the add() expression with the float() expression (as per the second parameter) as it is not in the correct format:
HTH
Jay
Community Power Pla... on at

Like (0)

Report

Re: Extract values from list

Full result below
Community Power Pla... on at

Like (0)

Report

Re: Extract values from list

Hi Jay,

I am still having issues with this, please see my setup and then the error:
Jay-Encodian 2,920 on at

Like (1)

Report

Re: Extract values from list

Hey @Anonymous
Here you go:
Expressions for ease of copying:
Compose: split(replace(replace(replace(variables('Value'),'[',''),']',''),'"',''),',')
Compose - Split: split(items('Apply_to_each'),'£')
Compose - Add the Values: add(variables('Total'),float(outputs('Compose_-_Split')[1]))
Output:
HTH
Jay
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
abm abm 32,492 Most Valuable Professional on at

Like (1)

Report

Re: Extract values from list

Hi @Anonymous

You could do this in different ways.

Read each values from the array. Next for each value use a split function to split the values between '-'. Finally again use a replace function to remove the pound sign. Then add this to a variable and increment every time.

If you want more help let me know. I could send some sample flow steps for you.

Thanks