cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Convert Strings from Excel to Integer

Hi Community, Please, I need help with my current flow.

1. I have a flow that is getting a cell value from Excel online file

2. I want to use condition action to check if the value is greater than a particular number

 

a. I have initialized a string variable with the value retrieved from the Excel sheet

b. I used Compose action to convert the string to integer, and

c. I use a condition action to check if this output is greater than a number of not.

 

When I checked the output, I always see that "0" is been retrieving a number.

 

I will appreciate if anyone here can help resolve this.

 

olacharles_0-1593731064382.png

 

3 REPLIES 3
Super User
Super User

Can you please show the screenshot from the run?
Specially of the Initialize Variable and Compose statement.

Also can you please tell the compose formula?

Please find the details below:

compose variable formula.jpgFlow error message.jpg

Frequent Visitor

The value I am pulling is a calculated number. could this be the reason why it's returning zero "0"?

 

If Yes, How can I make it return the real value?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (11,248)