Solved: Re: How to add a new row and update an existing ro...

Anonymous · ‎01-13-2023

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

Hardesh15 · ‎01-13-2023

@Anonymous You flow design should be like this-

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

@Hardesh /Gopenly.in

View solution in original post

Hardesh15 · ‎01-17-2023

@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

View solution in original post

Hardesh15 · ‎01-13-2023

@Anonymous You flow design should be like this-

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

@Hardesh /Gopenly.in

Anonymous · ‎01-16-2023

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 · ‎01-16-2023

@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

Anonymous · ‎01-16-2023

Hi @Hardesh15 ,

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

Cool solution!

Kind regards,

Rifat

Anonymous · ‎01-16-2023

Hi @Hardesh15 ,

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

The result is:

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 · ‎01-16-2023

@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

Anonymous · ‎01-16-2023

Hi @Hardesh15 ,

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

Sharepoint:

PowerAutomate:

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

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

Anonymous · ‎01-17-2023

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

Hardesh15 · ‎01-17-2023

@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

Anonymous · ‎01-17-2023

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

nagampally · ‎04-25-2023

what to write in row ID in update row??

nagampally · ‎04-25-2023

what to write in row ID in update row??

nagampally · ‎04-25-2023

What is the company code you remove in update step?

Anonymous · ‎04-26-2023

The code of the legal entity. Once a data is created, the code of the legal entity cannot changed anymore, so in the update a row step you have to leave it blank.

Anonymous · ‎04-26-2023

you can get the row ID of the specific row when you do a list of all data in a previous step with a filter to get the specific one. Then you can you use in the update step the row id as a dynamic value.

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

Helpful resources

Calling all User Group Leaders and Super Users! Mark Your Calendars for the next Community Ambassador Call on May 9th!

April 2024 Community Newsletter

Tuesday Tip | Update Your Community Profile Today!

Hear what's next for the Power Up Program

Super User of the Month | Ahmed Salih

Tuesday Tip: Getting Started with Private Messages & Macros