Need help in deleting SP list item correspondence to Data verse Table

(0) Share

Report

Posted on by ajaythakur22

The task is to delete an entry from a SharePoint list when its same entry is deleted from Dataverse Table.

Here Automate Flow is used and Trigger is: when a row is added, modified and deleted [Dataverse trigger]

then Action as - delete Item [SharePoint Action]

But problem is that it is throwing an error as ID is empty/null.

Can anyone please help with a solution to this?

Please find screenshot attached for reference.
Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@ajaythakur22

How are you relating the SharePoint item to the dataverse row?

Was this reply helpful? Yes No
ajaythakur22 19 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly
For relating SharePoint List to Dataverse row, PowerApps DataFlow feature is used.

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!
@ajaythakur22

So this is the column that refers to the ID you need to get from the Dataverse Row so you will be able to delete from the Sharepoint

So when you use the when an item is modified / Deleted , the problem that you can't get the column that is equal to the SharePoint item ID because the flow works in asynchronous mode so it actually run after the item is deleted and unfortunately you can get through this any of the information so you want be able to get the sharepoint list Id to delete.

Suggested Solution here:

1. Add a new field which can be a Two Options called DeleteRecord

2. Your flow trigger will run on when a record is Modified - with filter

schemanameofthedeletebuttonfield eq true

3. Delete from Sharepoint first

4. Delete from dataverse.

Hope this makes sense!

Was this reply helpful? Yes No
ajaythakur22 19 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly
Can you please elaborate point 1 and 2 from your solution? I'm not getting what should be done exactly.
Thanks.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ajaythakur22

So what I am saying in dataverse instead of using the delete button use a custom field / column to handle the delete action and then your flow to be triggered based on the change of the new field.

Hope this makes sense!

Was this reply helpful? Yes No
KMahi 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly ,

May I know briefly about this?
Like what changes to be done on new field. And, how this will help to delete from the SharePoint.

Thanks!!

Was this reply helpful? Yes No
ajaythakur22 19 on at

Like (0)

Report
Copy link

Link copied!

I am getting following error. Sharepoint item is deleted but unable to delete dataverse item.

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@KMahi

The new field will trigger the flow and the flow will then be responsible for deleting the SharePoint list item and the dataverse item. If it is not clear enough I can try to replicate and provide an example.

Was this reply helpful? Yes No
ajaythakur22 19 on at

Like (1)

Report
Copy link

Link copied!

@Mira_Ghaly
Thank you for your kind help. The issue is resolved now.

Was this reply helpful? Yes No