Forum Discussion
Loubnielsen
Sep 05, 2019Copper Contributor
Create distribution list from a SharePoint list
Hi I have a SharePoint list with a names column and an emails column, like: Name Email Louise louise@mail.com Jack jack@mail.com Hanna hanna@mail.com I would like to now i...
Viccy
Jan 13, 2023Copper Contributor
HaneyTrevor I am using your instructions for creating a flow to add to a distribution list. You said at the end of your instructions you also add a "delete" command. Can you explain why? Thank you!
HaneyTrevor
Jan 13, 2023Copper Contributor
Viccy I made the second flow to remove people from the SharePoint list out for two main reasons. First, and easiest, is that SharePoint lists have a maximum of (I think) 500 items. The distro list I was working with is over 2000. The second reason is more of a cleaner programming logic. Person A signs up to the distro, they get added to the SharePoint list, no problem. Person B signs up to the distro, they get added to the distro; Person A shouldn't be added to the distro a second time, but they're on the SharePoint list so maybe(?). Now lets expand further and assume there's Person A, Person B, Person C, and Person D on the "add to distro" SharePoint list. Person C no longer wants to be in the distro list, MS Flow removes them from the distro. Note: Person C is still on the "add to distro" SharePoint list. Now, if, Person E wants to be added to the distro, MS flow might add Person C back into the distro.
All the explanation to say you probably don't need the delete functionality, but it's a best practice to have it. Hope that helps and explains things.
- ViccyJan 13, 2023Copper Contributor
HaneyTrevor That makes sense. So, what I am doing is I have one list of people getting added and deleted. In that case, I don't need a delete function, correct?