I have a SharePoint list. List A. It contains just one column - team members name - of type People. Currently it has 6 people but might increase depending on situations.
I have a second SharePoint list, List B, that contains four columns - Course Code, Course Name, Course Description.
I have a third SharePoint list, List C, that contains five columns - Course Code, Course Name, Course Description, Assigned to, Completion status.
When I add a new course in List B, it should get all the team members from list A, get each course detail from list B, and save their all the people's name/email id for EACH course in List C. so each course should be assigned to all the people.
e.g., if we have 10 courses, and 6 people, as soon as I add a course detail in list B, the flow should run and it should assign 'each' course to all the people, and make 10x6 = 60 entries in List C.
Each of those 6 people then can save their completion status as and when done, later.
Is it possible using Power Automate?
6
Share
Report
All responses (
Answers (
