
Announcements
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