cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlueCar
Advocate IV
Advocate IV

SharePoint Get File Properties: Extra space (" ") added to managed metadata properties, that are multitagged

1. A document library with a property called "Product model". This property is managed metadata and allows multiple tags to be added to this property.

2. I have a document that has multiple product models tagged.

3. Use the SharePoint: Get File Properties

4. The output shows the first product model tagged in its correct form: "ProductModelX".

5. The rest of the product models have an extra space in front of them: " ProductModelY".

 

2019-06-21_10h29_45.png

Output from my product model property - the first entry with no problems:

2019-06-21_10h32_15.png

Output from my prodct model property - all of the rest of the entries:

2019-06-21_10h35_10.png

 

I have checked the managed metadata - everything is fine. If I rearrange the tags on the file, so another label is the first one, that one is fine, but the one that was the first before now has a space in front.

 

The workaround for this is of cause to trim the label before passing it on in the flow.

3 REPLIES 3
v-zhos-msft
Solution Sage
Solution Sage

Hi @BlueCar ,

I have made some tests on my side, it has the same issue as yours.

As the pic is shown below, when you add multiple values in the 'Managed Metadata' column, there is a space between each value.

I think it's the cause of the issue.

Capture2.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Zwart
Frequent Visitor

@BlueCar How were you able to overcome the space issue? I am running into this and although I can create a variable that has the space removed, I cannot seem to preform any conditions on it later on in the flow. Regards, Dirk

Hi Zwart,

I ended up using a trim function the place that I needed the individual tag-values inserted. See below.

 

BlueCar_0-1618469931385.png

And the text from the trim function is:

trim(body('Parse_JSON_to_get_Product_Model_name')?['Label'])

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Users online (73,305)