Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ozXC1tgGmUcQ4nF8EgVkDB
Power Automate - Building Flows
Answered

Dataverse to List flow (create/update/delete)

Like (0) ShareShare
ReportReport
Posted on 9 Oct 2023 16:13:51 by 192
 
I am working on a flow to basically mirror a Dataverse Table to a Sharepoint List. The flow is running however it is creating countless entries for the same item as well as blank items. I followed a video to create the flow and must be missing something critical. My end goal is the following:
 

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:

 

michellecoslet_0-1696867800813.png

 

 

 

 

michellecoslet_1-1696867800765.png

 

 

 

 

The Unique identifier for entity instances in the Dataverse table is EmployeeWithFullNamesid

 

Here is a screenshot of my data from my Dataverse Table:

michellecoslet_2-1696867800815.png

 

@Expiscornovus 

  • michellecoslet Profile Picture
    192 on 11 Oct 2023 at 16:18:39
    Re: Dataverse to List flow (create/update/delete)

    Works!

     

    Note: I did have to change the name back to RecordID in the filter and added the single quotes. 

    Thank you!!!

  • michellecoslet Profile Picture
    192 on 11 Oct 2023 at 16:11:51
    Re: Dataverse to List flow (create/update/delete)

    Not a problem - here is how I have it setup now:

     

    michellecoslet_0-1697040568014.png

     

    michellecoslet_1-1697040608384.png

     

    i originally had this field named "Record ID" but changed it to "ID0" thinking perhaps there was an issue with the naming. neither fixed the error however.

  • Verified answer
    Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 11 Oct 2023 at 16:01:28
    Re: Dataverse to List flow (create/update/delete)

    Hi @michellecoslet 

     

    This seems to be strange, yesterday the dynamic content which i add in switch was showing like triggerBody()?['body']?['SdkMessage'] 

    But now it is showing as triggerOutputs()?['body']?['SdkMessage'] i should have notice it earlier, 

     

    So you are correct with respect to your expression in switch action.

     

    Now coming to the error, could you show how you have written the filter query in get items under Update, this would help to understand what has gone wrong in flow ?

     

    The filter query should be like this :

    Nived_Nambiar_0-1697040159212.png

     

    The new table dynamic content should be enclosed within single quotes. I think you have enclosed in double quotes.

     

     

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • michellecoslet Profile Picture
    192 on 11 Oct 2023 at 15:37:16
    Re: Dataverse to List flow (create/update/delete)

    I get a litle closer if i use the following in Switch:

    michellecoslet_6-1697038630526.png

     

     

    Result:

     

    michellecoslet_5-1697038598681.png

     

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 11 Oct 2023 at 15:34:13
    Re: Dataverse to List flow (create/update/delete)

    Hi @michellecoslet 

     

    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 ?

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • michellecoslet Profile Picture
    192 on 11 Oct 2023 at 15:28:13
    Re: Dataverse to List flow (create/update/delete)

    michellecoslet_2-1697038084881.png

     

     

    run test:

    michellecoslet_0-1697038005536.png

    i just get a download link that leads to a blank page (no data downloaded):

     

    michellecoslet_1-1697038052337.png

     

    now, if i run the compose on just 'body', I get the following:

     

     

    michellecoslet_4-1697038250241.png

     

    {
      "cr2fa_emp_statuscode": "Active",
      "cr2fa_attendancestatus": true,
      "cr2fa_employeewithfullnamesid": "bfbf2215-a466-ee11-9ae7-000d3a1a3c76",
      "cr2fa_emp_name_lfm": "Vang, Mai See",
      "_owningbusinessunit_value": "2c2bb339-412e-ec11-b6e5-000d3a582004",
      "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
      "_owningbusinessunit_type": "businessunits",
      "statecode": 0,
      "_statecode_label": "Active",
      "statuscode": 1,
      "_statuscode_label": "Active",
      "cr2fa_accrueddays2": "0",
      "cr2fa_emp_lastname": "Vang",
      "cr2fa_emp_department": "SHOP FLOOR",
      "cr2fa_emp_employeeid": "442",
      "_ownerid_value": "6d861b40-412e-ec11-b6e5-000d3a582004",
      "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
      "_ownerid_type": "systemusers",
      "modifiedon": "2023-10-11T15:02:23Z",
      "cr2fa_emp_recordid": "993FC8E6-FC44-42EB-9937-7A772AF703C0",
      "_modifiedby_value": "6d861b40-412e-ec11-b6e5-000d3a582004",
      "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
      "_modifiedby_type": "systemusers",
      "cr2fa_emp_firstname": "Mai See",
      "createdon": "2023-10-09T13:02:31Z",
      "_createdby_value": "6d861b40-412e-ec11-b6e5-000d3a582004",
      "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
      "_createdby_type": "systemusers",
      "ItemInternalId": "bfbf2215-a466-ee11-9ae7-000d3a1a3c76",
      "SdkMessage": "Update",
      "RunAsSystemUserId": "6d861b40-412e-ec11-b6e5-000d3a582004",
      "RowVersion": "806297294"
    }

     

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 11 Oct 2023 at 15:10:11
    Re: Dataverse to List flow (create/update/delete)

    Hi @michellecoslet 

     

    to investigate the issue, we need to figure out what is the expression output of triggerBody()?['body'] , could you check that using compose action ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • michellecoslet Profile Picture
    192 on 10 Oct 2023 at 20:23:28
    Re: Dataverse to List flow (create/update/delete)

    After several attempts at rewriting the expression, it finally displayed like yours:

    michellecoslet_1-1696969401642.png

     

    However i still receive the error on update and create so far.

     

    michellecoslet_0-1696969360819.png

     

  • michellecoslet Profile Picture
    192 on 10 Oct 2023 at 19:19:29
    Re: Dataverse to List flow (create/update/delete)

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

     

    michellecoslet_0-1696965539415.png

     

    michellecoslet_1-1696965561473.png

     

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 10 Oct 2023 at 15:39:36
    Re: Dataverse to List flow (create/update/delete)

    Hi @michellecoslet 

     

    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

    Nived_Nambiar_0-1696951571030.png

     

    I have designed sharepoint list which has columns: NewTableID : Which represents new table id (record id in dataverse table), A,B,Sum.

    Nived_Nambiar_1-1696951627484.png

     

     

    Flow is designed like below:

     

    Step1:

    Flow is triggered with below trigger

    Nived_Nambiar_2-1696951675334.png

     

     

    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

    Nived_Nambiar_3-1696951789587.png

     

    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

    Nived_Nambiar_5-1696951929513.png

     

    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

    Nived_Nambiar_6-1696952128141.png

     

    Nived_Nambiar_7-1696952319646.png

     

    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.

     

    Nived_Nambiar_8-1696952341647.png

     

    Nived_Nambiar_9-1696952364346.png

     

     

    Hope this helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 45

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 25 Super User 2025 Season 1

#3
Chriddle Profile Picture

Chriddle 21 Super User 2025 Season 1

Overall leaderboard