the following duplicates are not added nomacs

I cannot use the filter array to lookup the ID in the Training Certificates list(list 2) becuase there is already many entries for the document ID but they are associated with different users that need trained. In the Training Certificates list(List 2) I am creating an Item for each of the users that need trained from the Training List when a new item is created or modified. The Training list(List 1) has a person field that you can enter multiple name of users that need trained when the Document is changed and approved. I have the same scenario as above with two lists that should have new items triggered when the status field changes. List 1 is a Training list that has a document ID for a document that requires training. Great reply but I have another similar scenario I hope you can help with. TaskName field and Due Date field set to corresponding dynamic contents of the trigger. Title field set to following formula: item()? Within 'Apply to each' action, add a 'Update item' action, Id field set to following formula: item()? Within 'If/no' branch of Condition 2, add a 'Apply to each' action, input parameter set to output of 'Filter array' action. Within middle drop down, choose is equal to.Īdd a 'Condition 2' action, click 'Edit in advanced mode', type the following formula: 'If/yes' branch of Condition 2, add a 'Create item' action, Title field, ItemIDFromList1 field, TaskName field and Due Date field are set to corresponding dynamic contents of the trigger. Add a 'Filter array' action, From set to output of 'Get items' action, within Condition box, left input box set to ItemIDFromList1 dynamic content of 'Get items' action, right input box set to ID dynamic content of the trigger. Within 'If/yes' branch of Condition, add a 'Get items' action, specify Site Address, List Name set to List 2.Within middle drop down, choose is equal to. Add a Condition, left input box set to Status Value dynamic content of the trigger, right input box set to Complete.Add a 'When an item is created or modified' trigger, specify Site Address and List Name set to List 1.I have made a test on my side and please take a try with the following workaround: TaskName column is a Single line of text type column and Due Date column is a Date type column. List 2: Note: ItemIDFromList1 column is a Number type column, which is used to store the item ID from the List 1. Note: TaskName column is a Single line of text type column, Due Date column is a Date type column and the Status column is a Choice type column (Available values: In Progress and Complete).

I have created two SharePoint lists on my side and the data structure as below: Hi you please share a bit more about your two SharePoint lists (List 1 and List 2)?ĭoes the List 1 and List 2 have same data structure?

The following duplicates are not added nomacs