web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Handling Currency Data...

Power Automate

Suggested Answer

Handling Currency Data Type Mismatch Between Microsoft Forms & SharePoint List

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Ellis Karim 11,937 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation