Extract values from list

[Anonymous]

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 

[abm]

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

[Jay-Encodian]

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.

[Anonymous]

Hi Jay,

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

[Anonymous]

Full result below

[Jay-Encodian]

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

[Jay-Encodian · Accepted solution]

@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

[Anonymous]

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:

[Anonymous]

Thanks Jay, all sorted now !

Cheers for your help.