Forum Discussion
Moving selections from Multiple columns, into one
MeganAcuzar the easiest way to do it is with a calculated column but it would give you the results without the "&". This is also quite straightforward to do with a flow in Power Automate if you don't need the "&". The result would be Word PowerPoint or SharePoint Word PowerPoint. If you really do need that "&" then the flow becomes more complex because you have to make sure there is no "&" before the first portal selected Yes. Let me know whether you need it or not and I'll give you the solution.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
No need for the "&" symbol 🙂
We have a lot of different portals so you have to scroll right for a while to see the options that the user is requesting. We just want a condensed column where we can see which portal they are requesting without having to scroll. Ultimately this will be updated in another user list that keeps track of which user has access to which portal (that's another issue i'm trying to figure out).
Your help would greatly be appreciated!