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

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Jay,

I am still having issues with this, please see my setup and then the error:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Full result below

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Jay-Encodian 2,920 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks Jay, all sorted now !

Cheers for your help.

Was this reply helpful? Yes No