cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olacharles
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
Rahber
Super User II
Super User II

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

olacharles
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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,324)