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

Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to add a new row a...
Power Automate
Answered

How to add a new row and update an existing row in dataverse table from a sharepoint list

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Hi all,

 

as it will be my first use of the sharepoint connector I am a little bit confused in using it.

I have the following requirement:

 

1. HR employee uses a sharepoint list to track the candidates to hire

2. Whenever a row (called item?) in the sharepoint list is created/added, there should be a trigger and I want to have the data of this specific row.

3. When I get the specific row and its data I want to add a new row to the "candidate to hire" entity in dataverse.

4. Whenever a column (status of application) is updated (for example to "send labor contract"), I want that the existing row in dataverse is also updated (also "status").

 

Can someone tell me the correct names of the steps please?

 

Kind regards,

Rifat

Categories:
General topics
I have the same question (0)
  • Verified answer
    Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on at

    @Anonymous You flow design should be like this-

    Hardesh15_0-1673625114081.png

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Hardesh15 ,

     

    thanks for your quick answer.

    Can you explain me the condition you set up in detail? Why did you choose this condition?

     

    Kind regards,

    Rifat

  • Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on at

    @Anonymous Whenever you create a line item in SharePoint list, Created and modified column values are same at this time and when someone update that item then only modified column value change. So in condition if created eq to modified means new item is created & if created not eq to modified means item is updated.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Hardesh15 ,

     

    thank you very much. I tried it and it functions!

    Cool solution!

     

    Kind regards,

    Rifat

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Hardesh15 ,

     

    now I have a problem. A step is not done when I modify an existing data. Following steps:

     

    Rifo50_0-1673873277753.png

     

    The result is:

     

    Rifo50_1-1673873339683.png

    The last step of updating the existing data does not function, but there is not error. The flow is officially succesful.

    Any ideas?

     

    Kind regards,

    Rifat

  • Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on at

    @Anonymous  What is the output of allcandidates action? is it zero?

    expand this action and share.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Hardesh15 ,

     

    the output is not empty. The correct data is found:

     

    Sharepoint:

    Rifo50_0-1673886777992.png

     

    PowerAutomate:

    Rifo50_1-1673886874339.png

     

    So, the input to the "update a row" step is correct, but the output gives an error message:

     

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
    <title>404 - File or directory not found.</title>
    <style type="text/css">
    <!--
    body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}
    fieldset{padding:0 15px 10px 15px;}
    h1{font-size:2.4em;margin:0;color:#FFF;}
    h2{font-size:1.7em;margin:0;color:#CC0000;}
    h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;}
    #header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;
    background-color:#555555;}
    #content{margin:0 0 0 2%;position:relative;}
    .content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}
    -->
    </style>
    </head>
    <body>
    <div id="header"><h1>Server Error</h1></div>
    <div id="content">
    <div class="content-container"><fieldset>
    <h2>404 - File or directory not found.</h2>
    <h3>The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.</h3>
    </fieldset></div>
    </div>
    </body>
    </html>

     

    And of course I did not made any changes manually in dataverse. So, I do not know, why this error message appears.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Hardesh15 ,

     

    I solved it, in the update step I had to remove the company code as it is not allowed to update this filed after creation.

     

    But now, I have another little problem. In my sharepoint list I have created a date field without time. I want to add this date field in my flow, but the date field does not appear as a dynamic value. I only find the dynamic values for the dates of modification and creation.

     

    Any ideas?

     

    And of course thanks again for your help!

     

    Kind regards,

    Rifat

  • Verified answer
    Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on at

    @Anonymous Please refresh your browser window after save.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Thanks again, although I refreshed it several times, now it appears 🙂

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

News and Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans