Handling Currency Data Type Mismatch Between Microsoft Forms & SharePoint List

(0) Share

Report

Posted on by CU25122255-0

Hi, I'm currently working with a SharePoint list that is populated by responses from a Microsoft Form. However, my SharePoint list has a Currency column, while Microsoft Forms doesn't have a Currency data type. This is causing my Power Automate flow to fail when trying to insert a value into the Currency column because of a data type mismatch.

How can I handle this situation, converting the form's numeric response into the correct format for the Currency column in SharePoint?

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report
Hi @CU25122255-0,

I think the Microsoft Form will store the currency value as text.

In that case use the float() function to convert the text into a number, for example:

float('10,000.33')

returns this result: 10000.33

Ellis Karim

Blog: https://elliskarim.com

Was this reply helpful? Yes No