cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VFXPro1
Level 8

Why is Open with Excel gone with the new CDS for apps?

I have a client that needs to edit CDS data in batch to clean up dirty data all the time.   With the previous CDS and the Excel add-in, it was a breeze.

 

Will this feature be back?   {insert some a picture of someone on their knees begging}  🙂

1 ACCEPTED SOLUTION

Accepted Solutions
PowerApps Staff CWesener
PowerApps Staff

Re: Why is Open with Excel gone with the new CDS for apps?

Thanks @VFXPro1 - we are working on releasing the Excel add-in at the moment, it's planned to be availabe again shortly.

Thanks,
Clay.

View solution in original post

6 REPLIES 6
Yahya
Level 10

Re: Why is Open with Excel gone with the new CDS for apps?

I am aware that CDS excel add in will be 'returned' to Spring Update CDS 2.0. I only hope it wil be made properly, that the "look up" list shows the "Primary Name" Not Primary ID, plus other improvements. 

 

 

PowerApps Staff CWesener
PowerApps Staff

Re: Why is Open with Excel gone with the new CDS for apps?

Thanks @VFXPro1 - we are working on releasing the Excel add-in at the moment, it's planned to be availabe again shortly.

Thanks,
Clay.

View solution in original post

VFXPro1
Level 8

Re: Why is Open with Excel gone with the new CDS for apps?

Thank you so much!! 🙂

Yahya
Level 10

Re: Why is Open with Excel gone with the new CDS for apps?

Hi @CWesener, please ensure that lookup list shows a Name not an ID inside the excel sheet. I know that via PowerQuery I can combine 2 or more tables and choose columns I want, but with CDS 2.0 lookup now points to a field name, this should be possible in a single excel sheet.

VFXPro1
Level 8

Re: Why is Open with Excel gone with the new CDS for apps?

Here are 2 possible options...
 
1. Prompt for an option after clicking on "export to excel" asking to pick for keeping the internal "lookup ID" value or the display value.  
 
2. Export 2 columns (Lookup column: ID, Lookup column: DisplayValue)
 
This way, everyone is happy...
PowerApps Staff CWesener
PowerApps Staff

Re: Why is Open with Excel gone with the new CDS for apps?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 427 members 6,510 guests
Please welcome our newest community members: