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

Community site session details

Session Id : yT6ow9j9M/pUAlKRFA86Rl
Power Automate - Using Connectors
Answered

Custom Connector and data type issue dropping trailing zero

Like (1) ShareShare
ReportReport
Posted on 3 Jun 2021 21:04:45 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

I have the same question (0)
  • Verified answer
    BrianCCampbell Profile Picture
    103 on 03 Jun 2021 at 23:50:35
    Re: Custom Connector and data type issue dropping trailing zero

    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 26 Nov 2021 at 14:46:51
    Re: Custom Connector and data type issue dropping trailing zero

    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 17 Oct 2022 at 06:38:40
    Re: Custom Connector and data type issue dropping trailing zero

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 707 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 499 Moderator

#3
chiaraalina Profile Picture

chiaraalina 312

Last 30 days Overall leaderboard

Featured topics

Loading started
Loading complete