Answered

Create multiple items in a SharePoint list based on two other lists

(0) Share

Report

Posted on by GabrielN

Dear All,

I'm still new to using Power Automate, so far I've been working in SharePoint Designer.
I would like to ask for help in how to put together the following process.

There are four lists that can be found on the same site:

JobPosition(JP): provides DepartmentPosition values for ER.Position and TV.Position lookup fields
EmployeeRegister(ER): contains data related to hiring a new employee
Task Vault(TV): contains task definitions
Checklist (CL): contains the data of the element created in the ER list and the elements created based on the elements of the corresponding TV list

The process:
1. A new record is created in the ER list
2. Based on the ER.Positon lookup (single select) field, search for all relevant TV elements based on the TV.Position (multiselect) lookup field
3. Iterate over TV list and if there is a value in the TV.Position lookup field that matches the value of the ER.Position lookup field, then create an element in the CL list

Unfortunately, I'm already stuck at the 2nd point. How do I iterate through the elements of the TV list and look for the ER.Position value in the TV.Position lookup field?

Here are a picture about the lists and the wished content in CL. Could you help me in this issue, please? Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

Hi @GabrielN ,

It just so happened that I had a few lists for testing that had almost the same structure as your lists:

so I tested and made a flow for your reference:

Overview:

Detailed actions:

You can set Value to:

{

"Task": items('Apply to each 2')?['Title'],

"Description": items('Apply to each 2')?['Description']

}

So the basic logic is to 1.looping on all tasks 2.looping on all positions of each task and check if is equal to the position from employee's creation. 3. if yes, then this task is what you need, append the task and description to the array variable. 4. looping on the final array variable and create new items in the Checklist.

Best regards,

Was this reply helpful? Yes No
GabrielN 92 on at

Like (0)

Report

Hi @v-jefferni ,
I am very grateful for your help! 👏 I will try your solution soon and give you a feedback!

Was this reply helpful? Yes No
GabrielN 92 on at

Like (0)

Report

Thanks again for your help. The workflow was compiled successfully and the items are created in CL list.
Here are the related steps:
All I needed to do was change the spaces in the name of the loop to "_" characters, because otherwise the workflow check threw an error:
After running the workflow by creating new item in ER list, the new items are created in CL list:

Thank you for your support again!

Was this reply helpful? Yes No
cripcrop 2 on at

Like (0)

Report

Hi, I wonder if either of you on this thread can help.
Im trying to do the same as here
I have created several sharepoint lists, attached.

I want to be able to add an ‘employee name’ and ‘machine’ to the ‘Employee generate training’ table and for it use power automate to go the the ‘machine skills’ table, pull out the ‘machine skills’ related to the chosen ‘machine’ and then populate the ‘Training’ table with all the skills for that machine and that user. eg there might be 31 skills for a particular machine, so it will create 31 rows of skills for that employee name.
I used this page and followed that – but I keep getting an error, as I think im perhaps choosing the wrong value in my condition. See Error in last screenshot
Thanks

Chris

Was this reply helpful? Yes No