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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

All responses (15)

Answers (2)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Hardesh15 ,

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

Kind regards,
Rifat

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No