Showing results for 
Search instead for 
Did you mean: 
New Member

Convert String to Float value from Google Sheets

Hi there, this my first post any my first flow.


I would to run a condition to compare results of JSON data to data from google sheets row.


The JSON data is number but think the google sheet data is in a string format which is preventing the evaluation of the condition. I've set the 'type' of the value in google sheets but it doesn't change anything.


I have two questions.

1) Do I need to store the JSON data in variable once its been returned?

2) How convert the data types (e.g from String to integer) so that I can use it in condition flow?compare.JPG 


Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (36,917)