Hi Guy,
I am using SharePoint online for one of our project and I would like to Automate the process of creating new list item using Min and Max value from another list. Example I have one list named Teams with columns -
1) Title
2) Min Players (Number)
3) Max Players (Number)
and other with with Team Members with columns -
1) Title
2) Details (String)
3) Created Date (Date & Time)
So if I updated or added new item in Teams like below
1) Team 01
2) 1
3) 5
Then it should automate and create the new list items in Team Members like -
1) Team Member 01
2) ""
3) Current Date Time
1) Team Member 02
2) ""
3) Current Date Time
1) Team Member 03
2) ""
3) Current Date Time
1) Team Member 04
2) ""
3) Current Date Time
1) Team Member 05
2) ""
3) Current Date Time
So it will create the list items based on Max number.
How should I do that? I worked with SPD 2010 workflows but this is new to me so your help is appreciated.
Regards,
Abhijeet