Delete relational data between tables

(0) Share

Report

Posted on by beeepaiva

Hey guys,

I'm making an application that I can generate reports after some time, and I have to keep all the data tracking...

Have that said...

I have some table related, (I'll not use the real structure but) example User, Place and Device, each time that the user send a Device to a new Place, a new row is created in a 3rd table like Devices in Places, that storage the Device key, Place key, User key (as this table have a relation with Place and Device and User) and some other information, in case a Device is deleted, or a User is deleted from the system, I don't want to loose in this table this text / tracking.

Is there a way to remove the parent data and keep this parent data as text in the child table like an historic, is this possible in some way instead of creating new three columns as text to save the Device Name, Place Name and User Name?

Thanks in advance!

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

AhmedSalih

6,680 Moderator on at

Like (2)

Report

Copy link

Link copied!

Hello, @beeepaiva , I am not aware of a way to do this without creating custom text columns. But have you thought of Deactivating the records in the Parent table instead of deleting them?

Note, The A deactivated record becomes inactive, which means it cannot be edited or used in establishing new relationships with other rows. However, all relationships created with the deactivated item are still available.

https://learn.microsoft.com/en-us/power-apps/user/deactivate-activate-account-contact

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

beeepaiva 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @AhmedSalih,

I didn't think about this option and neither know that Inactive items can't create new relationship or be related, thank you for this!
I also implemented a new config page so the User can see the Inactive date and can Active it if needed!

Thanks!!!
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@beeepaiva , always happy to help 🙂