Discussions

 View Only
  • 1.  % from QB to SharePoint shows incorrectly

    Posted 01-05-2021 13:56
    I have a pipeline that is sending a numeric % field value to a NEW SharePoint item where the column that receives my QB % is formatted to be a number and show as a percentage.  When the pipeline runs and sends the value from QB to SharePoint it displays as an incorrect % in the NEW SharePoint item.  Example below.

    QB % Field Value: 20%
    SharePoint Number column display value: 2,000 %

    Is there any trick to have the value of 20% come over exactly as 20% in SharePoint?

    ------------------------------
    Joshua Case
    ------------------------------


  • 2.  RE: % from QB to SharePoint shows incorrectly

    Posted 01-06-2021 09:38
    This is resolved.  Had to convert the percentage from my QB field to an integer by doing a number formula of dividing my percentage field by 1.

    Example Code:

    [My Percentage Field]/1

    ------------------------------
    Joshua Case
    ------------------------------