cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

delete row in Excel when CDS contact is deleted

When I delete one CDS entry from my contact entity all the rows in an excel file in one drive that mirrors the content of the CDS contacts entity  get deleted.

 

How do I filter the rows by ID so that only the excel ID that is no longer present in the CDS list gets deleted?

 

Thx - GERALD DAHL

1 REPLY 1
Highlighted
Resolver II
Resolver II

@GeraldDahl 

Entity Record in CDS have GUID , and if your export records to excel, it will be in hidden column A, Following is out of box sample records.

Excel.png

 When delete a row, you can specify which column to be "Key Column" and what is the value, In my example I take guid as key column and value from manually trigger input.

 

test.png

 

I tested above , only the row I specify in GUID input is delete. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (11,832)