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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Custom Connector and d...
Power Automate
Unanswered

Custom Connector and data type issue dropping trailing zero

(1) ShareShare
ReportReport
Posted on by 103

I created a custom connector to be used in a PowerApp that connects to an API that takes the following parameter (as a query in the URL):

sv=1.0

The data type is an integer and when I put the default value in for the parameter and test it, the value is input is getting changed to 1

If I run the test for the connector as 1 I receive an authorization failure. If I change the value from 1 to 1.0 on the test screen for that parameter it executes the test successfully. 

Thinking it is no big deal I saved the connector and added it to a PowerApp to test. PowerApps has the same behavior as I specify 1.0 as the value for the integer and it strips it back to 1 and I receive an authorization failure. I even tried formatting the number as Text(1,"0.0") which shows 1.0 but comes across as a string rather than text. If I further try this Value(Text(1,"0.0")) it comes out a just 1.


I would really like to fix this upstream (in the custom connector) to not have to deal with it in the PowerApp but am at a loss. Is this a browser behavior "helping" me by stripping the decimal off the 1.0 when I go from one screen to another? Anyone have any ideas?

 

Thanks,

 

Brian

Categories:
I have the same question (0)
  • Verified answer
    BrianCCampbell Profile Picture
    103 on at

    I found a solution. There is a policy section on the left-hand side of the screen (Actions,Triggers,References,Policies) and there I was able to create a policy that overrode the value query parameter. Not really sure why it worked there but not in the default of the parameter - but I will take it! 

  • Community Power Platform Member Profile Picture
    on at

    Hello @BrianCCampbell,

    can you please provide the reference how we can create the policy to overrode the value query parameter.

     

  • parasrajput Profile Picture
    3 on at

    Got policy, 

    name: <anything you want>

    Template: override query string parameter

    Query parameter name: sv

    query parameter value: 1.0

    Action: override

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard