Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / How to convert string ...
Power Automate - Using Flows
Unanswered

How to convert string in to int/number to update sharepoint filed.

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

 

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 we try to update it throws error with "Object must implement I Convertible . client Request Id"

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

 

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

I tried like below conversion but not working.

 

Help would be highly appreciated.

stringtointconvertion.PNG

  • Erica0214 Profile Picture
    Erica0214 on at
    Re: How to convert string in to int/number to update sharepoint filed.

    Hi @Anonymous 

     

    This could be done as simple as: int (variable)

     

    Annotation 2020-06-03 141842.png

  • Pstork1 Profile Picture
    Pstork1 66,004 Most Valuable Professional on at
    Re: How to convert string in to int/number to update sharepoint filed.

    I'm not sure there is anything available in Power Automate to convert a JPG to a binary string for upload.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: How to convert string in to int/number to update sharepoint filed.

    Hi @Pstork1 ,

    Really thanks, also we have a excel file that contains image (jpeg) now i would like to convert in to binary then update to SQL table field to refer that image in PowerApps

    Can you suggest me with steps please ..?

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: How to convert string in to int/number to update sharepoint filed.

    Hi Mates,

    Issue is resolved.

    solution is int(outputs('compose'))

    Thanks you

  • Pstork1 Profile Picture
    Pstork1 66,004 Most Valuable Professional on at
    Re: How to convert string in to int/number to update sharepoint filed.

    I believe your formula is correct, but you shouldn't have quotes around it.  Doing that inserts the formula as a string rather than a function.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans