cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Champion
Community Champion

CDM: Excel Add-In Design

In Excel, I can add columns for CreatedOnDateTime and LastModifiedDateTime using the Design feature.

 

However, after showing the columns, the column is blank and has no data. I wish to show the data so I could pivot and perform other filters using Excel formulas. Is there a way to get this data to show? I understand it is read-only data--maybe that is the cause for it being blank.

Microsoft Employee
@8bitclassroom
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: CDM: Excel Add-In Design

Hi,

 

Great to hear that you got those columns added. After you add new columns, you'll get a informative message indicating that you have to refresh before you see data. Did you do that refresh? If you don't click refresh, then you would see empty columns.

The Excel Add-in doesn't automatically refresh because it could take a long time depending on the query and we wouldn't want to automatically freeze the user out of doing other actions like additional design adjustments.

 

I hope that helps!

 

- Chris

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: CDM: Excel Add-In Design

Hi,

 

Great to hear that you got those columns added. After you add new columns, you'll get a informative message indicating that you have to refresh before you see data. Did you do that refresh? If you don't click refresh, then you would see empty columns.

The Excel Add-in doesn't automatically refresh because it could take a long time depending on the query and we wouldn't want to automatically freeze the user out of doing other actions like additional design adjustments.

 

I hope that helps!

 

- Chris

View solution in original post

Highlighted
Community Champion
Community Champion

Re: CDM: Excel Add-In Design

Hi

 

I have tried to add RecordID, CreatedOnTimeDate, and columns added automatically after Upate.

But even after refresh, nothing showed.

- As fas as I know, e.g, RecordID data auto-generated and I can have them showed-up in PowerApps (as in TextBox).

- However, they are not appended into Excel Add-in.

 

Any reason?

 

TQ

hpkeong
Community Champion
Community Champion

Re: CDM: Excel Add-In Design

Confirmed. Clicking refresh pulls in those columns.

 

The datetime is 7 hours ahead, so I assume it that all fields are calculated from GMT and PA adjusts for timezone within the app. If I perform calculations in Excel, my formulas will recalculate the datetimes. Is there a handy excel formula recommended for this?

Microsoft Employee
@8bitclassroom

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,284)