Hi All,
First time using Power Automate and learning a lot as I go.
I have a form where people identify an area, based on this area I want Power Automate to populate a Sharepoint List Choice column. However sometimes the form will be created with more than one area, at which point I need two text outputs to be sent to the list.
e.g.
Form Output = A, B or C Grouping on Column = Left
Form Output = D, E, F, G Grouping on Column = Middle
Form Output = H J K, Grouping on Column = Right
I've inserted an Initiialize Stream Variable.
Followed by a Condition (left) where I ask it to check if it is
OR, A, B, C. If Yes then the value 'Left' is shown using Set Variable, and then a second condition (middle) is created, if no then it just goes straight to the second condition (middle) to check.
The Condition Middle checks if the content is OR D, E, F, G, again if yes it returns 'Middle' using Set Variable and then onto the last condition for the items in Right.
Finally in the Create Item column I've got it to reference the Initilize variable created in the first step.
I've had it searching against the Compose - Output. It worked with the one condition to test, but as soon as I added all of these it failed when I had multiple options of set variable.
I presume this is something to do with the way it comes back. What is the best way to fix this?
Thanks
