Notifications
Announcements
1. When a NEW item is added to the Dataverse table, create a new item into the Sharepoint list
2. When an item is updated in the Dataverse table, update the same item in the Sharepoint list
3. When an item is deleted in the Dataverse table, delete the same item in the Sharepoint list
Here is a screenshot of my current flow:
The Unique identifier for entity instances in the Dataverse table is EmployeeWithFullNamesid
Here is a screenshot of my data from my Dataverse Table:
@Expiscornovus
Hi @michellecoslet
Could you share the screenshot of sharepoint list and dataverse table , from above screenshots, it is not clear
Nived N 🚀
LinkedIn: Nived N's LinkedInYouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!Your appreciation keeps me motivated. Thank you! 🙌
dataverse table:
sharepoint list after running test (after adding zzz and xxx test entries):
Last week, the accrued days was carrying over to the list, now it is now.
flow has been left on and it periodically updates the list with new information. here is the latest screenshot. My table has 36 entries (employees) however my sharepoint list is only showing 4 at the moment. and amand is listed 3 times with the same information.
I have designed the sample flow which does the record creation, updation and deletion in sharepoint list when row in dataverse is deleted,updated or created.
I have dataverse table like below which have three main column : A, B and Sum, The record id is NewTable
I have designed sharepoint list which has columns: NewTableID : Which represents new table id (record id in dataverse table), A,B,Sum.
Flow is designed like below:
Step1:
Flow is triggered with below trigger
Step 2: using the SdkMessage property which is present in body dynamic content of the trigger output which denotes the action done on record whether it is create, delete, update. Based on above property a switch is created like below
write that expression in switch so to get the SDKMessage value (since i could not see that property in dynamic content)
Now based on values of SdkMessage property, create three switch statements like below
1. Create:
This switch statement run when the record is created in dataverse table, so a item should be created in sharepoint list
Here for title , i just placed expression guid() for demo purposes, you can change it accordingly as per your requirement.
Delete: when record in dataverse table is deleted, item corresponding to that record is deleted in sharepoint list. we can fetch the record in sharepoint list by using filter query with NewTableID column since it has record id of dataverse table
Update: when record in dataverse table is updated, corresponding item in sharepoint list is also updated , the method of finding item in sharepoint corresponding to updated record is simmilar to what you have done in delete action.
Hope this helps !
first off, thank you for posting such a thorough response!!!
So I was able to replicate your setup except for the Switch expression. It is not working as a dataverse expression and as a result i get the following error at testing:
The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@triggerBody()?['body']?['SdkMessage']' is not valid. It is of type 'Null' but is expected to be a value of type 'String, Integer'.
After several attempts at rewriting the expression, it finally displayed like yours:
However i still receive the error on update and create so far.
to investigate the issue, we need to figure out what is the expression output of triggerBody()?['body'] , could you check that using compose action ?
run test:
i just get a download link that leads to a blank page (no data downloaded):
now, if i run the compose on just 'body', I get the following:
is there any body dynamic content in the output of trigger, could you place there instead ?
Also are you doing any update to dataverse table , like update, create or delete ?
I get a litle closer if i use the following in Switch:
Result:
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
