Share
Report
Hi all,
I have a flow that when an item in sharepoint list A is created and has a conditional value of 'Archive?' set as True, the flow will create a new item on a secondary archive list B, copy all the values from the item in list A and create them in list B (essentially copying and pasting one to the other). Once the list B item is created the next step is to send an email notification, and then delete the item from list A.
Some of the values in list A are multiple choice fields (such as location, or clause), I had previously set the flow to list all these multiple choice fields individually (see below) but the new item in list B would only display whichever location(s) that were in the item in list A (which is the behaviour that I want).
So far so good. This was observed to be working corrrectly for a while, however recently (I assume my workplace has pushed out an update to shrepoint or o365) whenever an item in list A is archived (and thus recreated on list B) all the possible locations are showing, not just the one selected on the list A item.
That's half the problem, I can remedy the above myself quite easily if I only want one location showing by changing the colomn settings to amend location from tickbox to dropdown. I don't want that however as I need multiple choice.
So, the second part to this is when I edit the flow from listing the individual locations to just having the location value in 'location value 1' field it creates an 'apply to each' automatically (this never happened previously, hence my assumption that an update has been pushed out). The consequence of this is that it allows for multiple locations, however it also creates mulitple entries (duplicates) on list B, one for each location.
As you can imagine, with having multiple locations, and also multiple other variables (such as ISO clauses) we need to list, it's unmanageable.
Hope the above made sense, any help greatly appreciated.
All responses (
Answers (
797
