Convert stings into values when extracting data from Excel in Flow

[fshaikh]

Hi,

I wish to convert strings into values when extracting data from Excel in Flow.

As you can see the below screenshot of my Data in Excel, I'm trying to get the sum of and Names = "Tim" and pass it to outlook connector. With ODATA filter query I was successfully in getting the data for Tim only now the challenge came up when I tried to sum the value by apply to each there is error " The provided value is of type 'String' ", I would appreciate community support in resolving this issue or suggest me better solution for this scenario. 

Data In Excel :

Error : 

Action 'Set_variable' failed

 

My Flow :

Thanks in advance..

Regards, Faraz Shaikh 

 

 

  

 

[DeepakS]

Hi @fshaikh 

You should convert the string to integer before performing sum. You can use int() function do that:

add(int(string value from excel),int(string value from excel))

Regards,

DS

[fshaikh]

Hi @DeepakS 

Thanks for you reply.. which step should I apply this formula in my flow & i need to use float as I few of decimal values.

appreciate your feedback

Regards, Faraz Shaikh 

[DeepakS · Accepted solution]

Hi @fshaikh 

Step where you adding the value , use float instead of int.

add(float(items('Apply_to_each')['Amounts']),float(variables['Total']))

Regards,

DS

[fshaikh · Accepted solution]

Hi @DeepakS 

Tested & it worked out with success thanks for you response.

this green color is sigh of relief 😀 

Red highlight was the missing peace of code

add( float( items('Apply_to_each')['Amount'] ), variables('Total'))

Regards, Faraz Shaikh