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