power automate will not update choice column 'get items' when the value is deleted
I'm using power automates 'get items' to copy and update SharePoint list items from one list to another. Everything works when I update items or change the value of choice column items. but if I completely delete the value, the destination list will retain the previous value that was entered. The if I enter a new value in my source list, my destination list will update again? I think this changed after the mass push out of co-pilot. My flow was created previously and now I'm trying to update it. Any ideas if there is a setting I'm missing or why this is happening?Sync options from Microsoft List choice column to Sharepoint folder choice column?
Hello, lovely people! I'm looking for a chance to sync a choice column's options from a Microsoft List to a choice column's options in a SharePoint library folder, the idea being that whenever I add, edit or remove an option, those changes are reflected on the same choice column's options. For this specific instance, I have a Microsoft List for inventory management that has a choice column for the product type (e.g: Laptop, Smartphone, etc.), and I want to sync all changes I do for the available options in the Sharepoint library folder's choice column for the same thing, so if I add the option for a "Printer" in the list's column, it would also be available in the folder's, and if I remove the "Laptop" option from the list's, it would also be removed from the folder's. Thanks in advance.
Send daily email using a multi choice column in Sharepoint
Hi, I am trying to create a flow that would send a daily email with the following conditions: 1. A column named "follow-up", with a multi-choice that consists of people name and different comittees that I would have a follow-up to do regarding the item. 2. For every item that "follow-up" is not empty, the email would list by "follow-up" choice, which item I would have to follow-up. 3. The "follow-up" choices are not static; from time to time I need to add a new choice so in the flow it can't be filtered with pre-determined choices. 4. Some items have a "due date", which would be included in the email Example: Email: "Daily follow-up elements" Follow-up choice 1 Item 1 Item 2 due 2022-12-05 Item 5 due 2023-01-08 Follow-up choice 2 Item 2 due 2022-12-05 Item 4 Follow-up choice 3 Item 1 Etc... I read a lot on the subject but wasn't able to find something that would solve what I need to do. Thank you!Format a Choice Column so it presents the items on individual lines rather than wrapping them?
Hi, I've had a good troll of the internet but I can't find an answer to my question, this kind of makes me think it's not possible, but considering how customisable SPO is now I find that hard to believe. I have a choice column that is configured to allow users to select more than one item. When this column is displayed on the list the items are separated by a comma and they are all wrapped. What I'd like to do is put a line break between each item so they are easy to read at a glance, what would be really good would be to bullet them but I'd be happy with separate lines. :) Does anyone have any thoughts on how I could achieve this? Thanks in advance RobPnP PowerShell - add choice column values
Hi Folks, Trying to run a PS Script to update a choice column in a site, but keep getting the following error: Exception calling "Remove" with "1" argument(s): "Collection was of a fixed size." The Scipt is: $SupplierChoices = Get-PnPField -Identity "Supplier" $SupplierChoices.Choices.Add($namechoices) $SupplierChoices.Update() $namechoices would look like the following: "Choice 1","Choice 2", "Choice 3" so on...
