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

string field to int not working !!

Hi,

 

I want to convert a String to an Int.

 

String field : "DEBUT_INT".

 

1.PNG

 

 

My Compose action takes out the string "number" with a previous Get Item. 

My Compose_2 action uses an Int Function to convert but it is not working.

2.PNG

 

 

This is the error message I get :

3.PNG

 

Thanks a lot for any help.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@charlyOueoueoue 

I have tried to reproduce at my side but it is working as expected no issue 

Mira_Ghaly_0-1660728407730.png

and it worked successfully

 

Mira_Ghaly_1-1660728467433.png

can you try removing and adding the action again?

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

ScottShearer
Super User
Super User

@charlyOueoueoue 

Like @Mira_Ghaly  I cannot reproduce your error.

Is there a reason that you can't change the SharePoint column to a number with zero decimals?

Have your tried using a trim() expression before converting to an int?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User
Dual Super User

@charlyOueoueoue 

I have tried to reproduce at my side but it is working as expected no issue 

Mira_Ghaly_0-1660728407730.png

and it worked successfully

 

Mira_Ghaly_1-1660728467433.png

can you try removing and adding the action again?

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
ScottShearer
Super User
Super User

@charlyOueoueoue 

Like @Mira_Ghaly  I cannot reproduce your error.

Is there a reason that you can't change the SharePoint column to a number with zero decimals?

Have your tried using a trim() expression before converting to an int?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

With no modification from my side, it works again !

 

Time helps ! 

 

Thanks for all.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,936)