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

How to convert string to int/Number

Hi Mates,

 

We have excel file to read field values, one column is there with ID (1,2,3 etc...)

I can update/create rows in SharePoint list field datatype is string only but not if datatype is number datatype.

when i try to update it throws error with "Object must implement IConvertible. clientRequestId"

Then i deleted that number field and recreated with String datatype then its working/updating,

 

but how can i update excel Id field with number datatype field.

I tried like below conversion but not working.stringtointconvertion.PNG

 

Help would be highly appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User III
Dual Super User III

Check my response to your other post.  You can's put quotes (") around a formula or it will become a string not a function.



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

View solution in original post

4 REPLIES 4
Dual Super User III
Dual Super User III

Check my response to your other post.  You can's put quotes (") around a formula or it will become a string not a function.



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

View solution in original post

Microsoft
Microsoft

Hi @kmk ,

So as @Pstork1 mentioned, you cant use quotes in the formula otherwise it will not work and see it with it as a string.

As you can verify in other posts asking a similar question as yours, you need to have the formula inserted into the dynamic content directly with no quotes: https://powerusers.microsoft.com/t5/General-Power-Automate/Error-while-convert-string-to-number/td-p...

In your case it would be int(outputs('Compose'))

 

Let me know if this helps. I have left the links to other similar posts so users can find this more easily:
https://powerusers.microsoft.com/t5/General-Power-Automate/Convert-text-to-number/td-p/40748
https://powerusers.microsoft.com/t5/General-Power-Automate/Error-while-convert-string-to-number/td-p...


Regards,
Ricardo

Hi @rimatos ,

 

Really for reply in-fact that string to int conversion is completed, but in the excel file we also have a images in the row,

By any chance

can we read images from excel like how as of now I can read string/number values...?

if yes how to convert that images in to binary format to update in to SQL table...?

kindly help me here this is major roadblock for now.

 

Hi @kmk ,


So to extract images from Excel yo have the following Community thread that might help you in that here:

https://powerusers.microsoft.com/t5/General-Power-Automate/Extract-image-from-Excel-embed-in-html-em...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Excel-and-Pictures/td-p/14946

 

In essence you need to have the columns as Image [Image] and teh relative URI path to the image.

As for the conversion there is also another thread that might be useful for your goal here:

 

https://powerusers.microsoft.com/t5/Building-Flows/Base64-to-Binary/td-p/318956

 

 

Hope this helps!

 

Regards,
Ricardo

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (21,083)