How to convert string to int/Number

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Help would be highly appreciated.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rimatos Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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/402837

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/402837

Regards,
Ricardo

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
rimatos Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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-email/td-p/297241

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

Was this reply helpful? Yes No