cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VFXPro1 Advocate V
Advocate V

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
Power Apps
Power Apps

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 Kudo Kingpin
Kudo Kingpin

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. 

 

 

Power Apps
Power Apps

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 Advocate V
Advocate V

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

Thank you so much!! 🙂

Yahya Kudo Kingpin
Kudo Kingpin

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 Advocate V
Advocate V

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...
Power Apps
Power Apps

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Users online (6,694)