Inserting Specific Data from one SharePoint List to another when a new entry is created.

(1) Share

Report

Posted on by HolJFitz

I have created two SharePoint Lists. Both lists are populated by separate MS Forms.

The first list is a Document Request List.

The second is a Document Priority list.

Once a new document request comes in, it adds a line to the Document Request list, from there an email is distributed to a committee who then fill out an MS Form with voting criteria. The results of which, updates a line in the Document Priority list.

Once the Document Priority Form is filled out and the new line is created in the Document Priority list, I would like to grab data from the Document Request list and update the Document Priority list. I am failing.

The Document Submission # in the Document Request list and the Document Request ID from the Document Priority list will be the same. So these values will be used to identify entries in both lists. If there is a match, it should update three columns. Otherwise it should do nothing. This is where I think I took a left turn.

The flow checker is telling me there is a possibility that it may trigger an infinite trigger loop. I can't see it. It also advises that it has run successfully in my tests. But nothing is updating as expected. I have left the if no action completely blank.

Any guidance would be amazing.

Categories:

AI Builder

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Its because the Trigger is for the Priority list, and you are Updating the Priority list in your flow at the bottom Apply to each so you are just going to be

non stop Triggering.

You need to add a Trigger Condition that will ONLY trigger when its Create, but this trigger does Create or Modified. Its your Modified part that will trigger nonstop

If you add a Trigger Condition so that it ONLY continues and fires IF its a Create, instead of a Modified, then you are fine.

Add trigger condition to your Trigger. Click the ... on the Trigger
Click Settings
In the bottom you need to add a Trigger Condition
@not(equals(triggerBody()['Modified'],triggerBody()['Created']))

Here is where you trigger the Modified Part.

Also, you are using a Filter array on your first Get Item 2 above... Just use an ODATA expression to compare
the FIeld to the value

so like [MySharePointField] eq 'MyIncomingValue' (assuming they are strings)

Was this reply helpful? Yes No
HolJFitz 13 on at

Like (0)

Report
Copy link

Link copied!

Thank you @FLMike,

I so appreciate your response. It makes sense to me until I try to put it into practice.

When I click on the ... at the Apply to each and access the settings, I am not sure what I am expecting to see to enter the trigger you have suggested.

I am either not in the spot I should be or just totally don't understand. This is the screen I am seeing.

What am I missing?

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You need to put the Trigger Condition in the Trigger. Here

and your apply to each at the top goes away completely and you just have your Condition that does the check on the length

Was this reply helpful? Yes No