web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need help in deleting ...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 19

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

Ss1.png
Ss2.png
I have the same question (0)
  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @ajaythakur22 

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

     

  • ajaythakur22 Profile Picture
    19 on at

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

  • Verified answer
    Mira Ghaly Profile Picture
    11,415 Moderator on at

    @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

    Mira_Ghaly_0-1649391835194.png

     

    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!

  • ajaythakur22 Profile Picture
    19 on at

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

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @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!

     

  • KMahi Profile Picture
    2 on at

    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!!

  • ajaythakur22 Profile Picture
    19 on at

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

    MicrosoftTeams-image (15).png
  • Verified answer
    Mira Ghaly Profile Picture
    11,415 Moderator on at

    @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.

     

  • ajaythakur22 Profile Picture
    19 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard