Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @staylearning ,
This is a forum for PowerBI. The power automate community might be able to help you. Microsoft Power Automate Community - Power Platform Community 🙂
Did I help you today? Please accept my solution and hit the Kudos button.
Hi @staylearning ,
This is a forum for PowerBI. The power automate community might be able to help you. Microsoft Power Automate Community - Power Platform Community 🙂
Did I help you today? Please accept my solution and hit the Kudos button.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |