Forum Discussion

JoshuaCase's avatar
JoshuaCase
Qrew Cadet
4 years ago

% from QB to SharePoint shows incorrectly

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
------------------------------

1 Reply

  • 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
    ------------------------------