You’re offline. This is a read only version of the page.
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?
Thanks for your answers
@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)
@Tim0711 0040/0049 is not a number! You should change your SharePoint column to single line of text.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
