Hi PowerApps Community -
I am trying to upload a dataset from Excel into a Common Data Service entity and am running into an annoying issue where the text that I upload is truncated. I tried to change the field type to "Multiline Text" and that did not resolve the issue.
Has anyone experienced a similar issue and are there any workarounds for this?
Are you using a custom entity? What are the data types for the fields?
Do you mean that a Text data field in your entity caused the issue so you changed it to Multiline text?
To test this issue, I create a custom entity which has data types Text, Number, and Picklist.
I create a simple Excel file which contains these three columns, then following the import data steps, the data is imported successfully.
The fields in my entity and the Excel file I used are:
Please refer to this doc for a reference:
Please try it again, if you are still having the issue, please feel free post back with more details about your entity and the Excel you are using.
Hi Yamao -
Yes, I am using a custom entity. I have tried several data types for the fields, including text and long text. I can try a few of the others that you mentioned, but am wondering if it would be possible for me to send you my spreadsheet so that you can have a look at it as well.
Thanks for your help!
You could send it to my email address at email@example.com.
I will help test it on my side.
Please provide the data type of each column, Brand, Support Type, Region, Unique Key, Time Period, Text.
I am trying to create a custom entity then try to import the data you have sent to me to test this issue.
All fields have a data type of text or long text. I am indifferent between using either data type as long as it works.
Thanks for all of your help! I really appreciate it.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.