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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Format for Currency in...
Power Apps
Unanswered

Format for Currency into forms

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Annotation 2022-07-11 102514.png 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/TotalEstimatedCost' is required to be of type 'Number/double'. The runtime value '"$1700"' to be converted doesn't have the expected format 'Number/double'.\

 

Hello the issue I'm having is that when I submit a form with a Dollar sign already the formatting doesn't work it only allows for the number without a "$" in the form submission, I'm just wondering if there is a way to automatically change the format so it automatically uses a $ whether or not they use it in the form submission.

Categories:
  • Shujaath_Khan Profile Picture
    1,111 Super User 2024 Season 1 on at

    hi @Anonymous 

    in total Estimated cost can you try below

    float(replace(variables('testmon'),'$',''))

     

    Thanks
    Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Where do I put that formula sorry I'm kind of new to Microsoft power automate.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

    When I put that there this is the error I get

     

    Annotation 2022-07-11 142115.png

  • v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    It may be caused by you still using the original dynamic content. The flow might fail to run if the value passed by the MS Form contains the '$' character.

    vyujincuimsft_0-1657698710635.png

    Maybe you could try to use the currency column, then use the expression provided by @Shujaath_Khan in Flow to remove the '$' character in the value.

    replace(Dynamic Content,'$','')

    vyujincuimsft_1-1657700403492.png

    vyujincuimsft_2-1657701116121.png

    Result Screenshot:

    vyujincuimsft_3-1657701341948.png

     

     

    Best Regards,
    Charlie Choi

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Annotation 2022-07-13 091051.pngAnnotation 2022-07-13 091137.png

    When I added the compose and used output for equipment with price it still didnt run the flow without that error

  • v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Maybe you could check if the OUTPUTS of Compose Action is correct.

    vyujincuimsft_0-1657764565840.png

    vyujincuimsft_1-1657764729489.png

     

     

     

    Best Regards,

    Charlie Choi

  • Shujaath_Khan Profile Picture
    1,111 Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    can correct as shown in snap below

    Shujaath_Khan_0-1657767762624.png

    Thanks

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Annotation 2022-07-14 090420.png

    This is the error I get 

  • Shujaath_Khan Profile Picture
    1,111 Super User 2024 Season 1 on at

    There seems to be variable testmon which you're trying to use but you've not initialized it,

    please either create it or remove it dependencies from create_item action

     

    thanks

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    How would I go by doing that I don't know how to do that

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 396 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 323

#3
WarrenBelz Profile Picture

WarrenBelz 193 Most Valuable Professional

Last 30 days Overall leaderboard