i am importing from SharePoint List to DATAVERSE. within the advanced editor I am creating a new column from a Date column and conversion of a text column to time into a new datetime column then converting to text.
I can preview the rows but anytime the dataflow runs it fails. i have attempted all sorts of different datetime approaches. the last reference i found said to load as text separated date and time with a space.
here are the relevant advanced editor rows.
Solved! Go to Solution.
@AhmedSalih disregard.... in my mapping i was taking the eventstarthr time column and trying to place it into a number. i didnt need this and chose none in mapping and everything came over.
This is the powerquery preview of datetime as text at the last step
when the dataflow runs all rows give this type of error
{"error":{"code":"0x0","message":"An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal '1:00 PM' to the expected type 'Edm.Int32'. ---> System.FormatException: Input string was not in a correct format.
Hello, @DaleORL, are you creating a new Dataverse table or loading the data into an existing table?
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
@AhmedSalih . This is a custom dataverse table i created. the column type is datetime.
@DaleORL, I think the issue is you might not be able to load text formatted data into Date and Time column. Would you be able to reformat your columns to date time in Power Query?
@AhmedSalih i original tried loading as datetime and that did not work. have tried all sorts of different methods. dates will load, time will not, nor datetime converted to text with a space between date and time.
@DaleORL, when your columns had the DataTime format in your Power Query, did you also have your DataTime Column setting in Dataverse Table as following:
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
@AhmedSalih disregard.... in my mapping i was taking the eventstarthr time column and trying to place it into a number. i didnt need this and chose none in mapping and everything came over.
User | Count |
---|---|
20 | |
11 | |
9 | |
5 | |
5 |
User | Count |
---|---|
31 | |
29 | |
15 | |
12 | |
9 |