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
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.
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.
I tested above , only the row I specify in GUID input is delete.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.