Hello,
I am creating a flow to copy items to a second list based on Status = Awarded. Both lists have 3 multiple select columns 2 of the columns are claims and are formatted nicely when created in the second list. The value column formatting is ugly. See screenshot below. How can I clean this up so it only shows the items in the drop-down list and not the extra brackets, braces and Value text?
@trishmalloy You need to ensure you are using the Select array when updating your SP list. Right now, you are inserting the array as a string of text.
For your multi-choice column, select this icon to input the entire array.
Insert the output from the Select action.
If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
IN THIS VIDEO:
âś… How to send multiple list items in a single email with a Power Automate Flow
âś… How to create a dynamic date range
âś… How to use the Convert Time Zone action
âś… How to use a Filter Query in the Get Items action
âś… How to count number of items in an array
âś… How to use the Select action to extract a users display name and email address
âś… How to create a unique list of email addresses
âś… How to use the Create HTML Table action
âś… How to customize the HTML Table with CSS styles
âś… How to use the Send an email (V2) action
âś… How to use the Append to String Variable action
âś… How to create a custom list of items for an email
âś… How to use the Send an email (V2) action
âś… How to display singular or plural text based on the number of items returned
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2