Answered

Excel to Sharepoint List Spaces

(0) Share

Report

Posted on by SionHuws

Hi can anyone here tell me why the following happens:

So I have an field in an excel which typically looks like this

B2939 H283939 12/12/22 3SJDSHGD

I understand it is unusual to have different data in one field but under the circumstances of how the system works this is essential.

I then have a power automate flow which uploads this data into the matching field on Sharepoint but it is uploaded like this:

B2939 H283939 12/12/22 3SJDSHGD

I'm guessing the list won't allow multiple spaces? Does anyone know a work-around for this?

Thanks!

Sion

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

It shouldn't remove the spaces when you output it to your SharePoint field. Are you able to show your flow and how you are adding the data to SharePoint?

Was this reply helpful? Yes No
Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SionHuws ,

I guess I reproduce your scenario, please refer to my below test:
In my SP list, there is a single line of text column named "test_text".

This is my action to update: the Name column has the same value as yours.

Result:

However, when I double click this column value, it shows me the whole value and it looks like this:
So, I believe the value is still the same, it's just looking like all the spaces are removed partly. No need to worry about this point.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
SionHuws 49 on at

Like (1)

Report
Copy link

Link copied!

Thank you! It appears that you are right. Thanks for going to the trouble of re-creating the scenario I appreciate your efforts.

Big Thanks!

Sion

Was this reply helpful? Yes No