web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : YH51FCqZAI4Nr46rja+Yx4
Power Automate - Building Flows
Unanswered

Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

Like (0) ShareShare
ReportReport
Posted on 24 Apr 2024 09:30:48 by 4

Hi everyone,

I'm currently working on a Power Automate Flow where I need to extract data from an Excel file and insert it into SharePoint. However, I'm encountering an issue with one particular value: "0040/0049".

The Flow is giving me an error stating that the value needs to be of type 'Number/double', but the runtime value doesn't have the expected format. I understand that the "/" in the value might be causing the problem.

Could anyone please guide me on how to properly format and convert this value so that it can be inserted into SharePoint as a number? I've tried a few approaches, but I'm still getting the same error.

How can I change my Flow that the numbers in Excel with "/" go into the Sharepoint Number field?

Tim0711_0-1713950897252.pngTim0711_1-1713950986140.png

 

Thanks for your answers

I have the same question (0)
  • RobElliott Profile Picture
    10,179 Super User 2025 Season 2 on 24 Apr 2024 at 11:46:16
    Re: Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

    @Tim0711 what has a Power Apps got to do with it and why does that stop you making changes? The problem is, as I said, that 0040/0049 is not a number and never can be. Even if you stripped out the / it would still be saved into SharePoint as 400049 (although you could use JSON formatting with the padStart function to display the leading zeros). You can't use a number column and will need to use a single line of text column.

     

    Rob
    Los Gallardos
    Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

  • Chriddle Profile Picture
    7,984 Super User 2025 Season 2 on 24 Apr 2024 at 11:06:20
    Re: Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

    @Tim0711 wrote:

    I need the Text "0040/0049" in the Number Field. Both Numbers with "/"


    That's not how it works 😉

  • Tim0711 Profile Picture
    4 on 24 Apr 2024 at 10:59:38
    Re: Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

    I need the Text "0040/0049" in the Number Field. Both Numbers with "/"

  • Tim0711 Profile Picture
    4 on 24 Apr 2024 at 10:49:10
    Re: Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

    There is a Microsoft PowerApp. Thats the reason why i cant change the collumn in a Text. Is there no reason to convert the Text into Number with the "/"

  • RobElliott Profile Picture
    10,179 Super User 2025 Season 2 on 24 Apr 2024 at 09:48:23
    Re: Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

    @Tim0711 0040/0049 is not a number! You should change your SharePoint column to single line of text.

  • Chriddle Profile Picture
    7,984 Super User 2025 Season 2 on 24 Apr 2024 at 09:47:03
    Re: Need help with Power Automate Flow: Converting "0040/0049" to a number for SharePoint

    Which number would you like to receive from “0040/0049”?

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete