Unanswered

Storing consignment numbers from CSV as string is cut short

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I am currently looking at trying to store consignment numbers in Sharepoint. I extract the data from a CSV, using Encodian Parse CSV and after converting it to JSON, I am able to extract the data. However, as its a text string, the number gets cut down from 1234567890 I can end up with the number 1.23456+13 for example. I tried to set the JSON extraction as being an integer, to read the data but it comes up as insisting its a string.

How do I stop these numbers being converted to such short abbreviations?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Re: Storing consignment numbers from CSV as string is cut short

Hi @Anonymous ,

Could you please explain more details about your requirement so we could better understand your issue?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Storing consignment numbers from CSV as string is cut short

Hi Alice,

So my CSV file contains a number of records as such:

[CODE]
"Referee","Name","Number","BagNo","Device","SIM","ID1","ID2","DispatchedDateTime","ConsignmentNo","ProductCode"
"Bob Jones","PARK AVENUE","OUT-12345 IN-54321","","Device1","","12345678910","987656789","8/6/2020 9:55:52 AM","12345432123454","ABC"
[/CODE]

The above is exactly as it would appear (quotes and all) which would be picked up from a file (which could be 150 records long or a lot more!). The routine picks up the data, puts it into JSON format, and then "for each" would run and extract the data then log it, so for example with the above CSV:
CSV > JSON > Add item to Sharepoint List "List 1"

[CODE]
List 1 - Field Referee - Bob Jones
List 1 - Field Name - Park Avenue
List 1 - Field Number- OUT-12345 IN-54321
List 1 - Field Bag Number - <blank>
List 1 - Field Device - Device1
List 1 - Field SIM - <blank>
List 1 - Field ID1 - 1.234567E+14
List 1 - Field ID2 - 987656789
List 1 - Field DespatchedDateTime - 8/6/2020 9:55:52 AM
List 1 - Field ConsignmentNumber 1.23454321E+14
List 1 - Field ProductCode - ABC

The "E+" and the full number being converted to a decimal is an unexpected result.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: Storing consignment numbers from CSV as string is cut short

Hi @Anonymous ,

I have made a test on my side and I'm afraid that the requirement couldn't be achieved in Microsoft flow currently.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Storing consignment numbers from CSV as string is cut short

Hi @v-alzhan-msft,

Ahhhh ok so this is a limitation of microsoft flow? rather than the data being input?

Thanks

Was this reply helpful? Yes No