Transform Data with Excel | Date value = null

(0) Share

Report

Posted on by KSven

182

Hi lovely Community,

when I deleting some Dates in Date Column of Dataverse Table in Excel, I can publish it successfully, but after review in Dataverse Table on PowerApps I've recognized theres "1900-01-01" instead of my deleted Date as "null".

Any Ideas how to set date values in Excel without getting "1900-01-01" in Dataverse Table?

Or is this a bug?

BR,

Sven

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @KSven,

Can you walk me through your process and how you are deleting the dates?

I did the following in a Model App:
1. Updated a date only field on a record to set the date at 5/10/2021
2. From the List view exported the records to Excel
3. Cleared the date in the Excel file for that record
4. Imported the data from Excel

It cleared the record's date successfully:

Are you doing this differently than above?

Thanks much,

Drew

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report

Hi @dpoggemann ,

thank you for your reply.

Here's the process:
1. I've a Dataverse Table and would like to make changes in Date Column. So I choose the Excel Add-In Power Apps to connect to my desired table.
2. Selecting relevant Columns with Power Apps Addin
3. Make some changes and select or type date values
4. Publish Changes to Dataverse Table.

--> Works fine, but when I delete one date value like "2021-01-01" to "" and publish it, it works, but when I check Dataverse table, there's "1900-01-01" as date value instead of "" or null.

Hope you can reproduce it..

BR,

Sven

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

Like (0)

Report

Any updates on this yet?

How to clear date columns through the 'Edit in Excel' ?

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report

Hi @Anonymous ,

we still have the issue., but we are already working with PowerApps to edit Date values.
Of course this is not solution.
Editing with Excel should work as well. I guess someone should open a support ticket for it...

BR,
Sven

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

Like (0)

Report

Hi @KSven

Yeah we have the same issue for a client but over 3000 records and even more date fields, too many to do it manually.

Can't seem to make it work with power automate either

Was this reply helpful? Yes No
P3Sven 119 on at

Like (0)

Report

Whats your issue with power automate? With Power automate it should work easy, I've done many times..

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

Like (0)

Report

Hi @P3Sven

Well this doesn't work:

How do you do it? thank you in advance

Was this reply helpful? Yes No
P3Sven 119 on at

Like (1)

Report

Well this is working:

Maybe you have to enable your Power Automate Settings to Experimental:

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

Like (0)

Report

Hi @P3Sven

Thank you! Now my flow works fine!

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

I have tried all the Excel ways ( Edit or Export) and still didn't get it to work. I resolved this issue with the DataFlows. Create DataFlow to upload data from Excel file to your Dataverse table and It will insert a blank value when the date is null.

Was this reply helpful? Yes No