I'm trying to connect a Microsoft Form to Microsoft Flow to Trello so that a new card is created everytime a work request is made.
1. Is there a tutorial for this kind of setup somewhere?
2. I have a question early on in the form (2nd or 3rd question) with 15+ options, all leading to different paths within the form. However, I can't figure out if I can repeat questions for multiple paths - e.g. "What is the title of your project?" - to pull that info in Flow and post to Trello, or if I need to break it out per path, e.g. "[Project1] What is the title of your project?"; "[Project2] What is the title of your project?", etc.
3. How do I set up Flow so that it pulls data from a Forms submission? It looks like it needs to make a call somewhere but the JSON is confusing to me. I'm not tech-illiterate but I have no idea how the JSON language is constructed. If there's a tutorial on this that would help a lot as well.
If I could just get these three questions answered, I think I can figure out the rest. I greatly appreciate any support provided.
If you want to connect a Microsoft Form to Microsoft Flow to Trello so that a new card is created everytime a work request is made,please create the form in the Microsoft forms and the add the trigger "When a new response is submitted" of Microsoft Forms connector,and the add action "Create a Card" of Trello connector.
For your question 2 and question 3,could you please explain more details about it?please share more details so we would try to provide a proper workaround for you.
Thank you very much for the assistance.
I was able to answer some of the questions I had myself, but need your assistance in regards to the image below.
What I am trying to create a set of if/then conditions that will go through all of the options on a particular question, and have a separate path for creating a Trello card for each option.
If the question is: What would you like to eat?
And the answers are:
[_] Pancakes [P]
[_] Eggs [E]
[_] Bacon [B]
[_] Waffles [W]
Add a condition where the answer to the question contains a unique identifier [UI]
IF YES: create new Trello card using information from the form submission
IF NO: check the next response for that question
Using this example, it would look like:
What would you like to eat? contains [P]
IF YES: create Trello card to make pancakes
IF NO: check the same question to see if the user chose Eggs [E]
IF YES: create Trello card to make eggs
IF NO: check the same question to see if the user chose Bacon [B]
I am trying to sort the data submitted to the form based on the answer to the question "what would you like to eat?" so that a different Trello card will be created depending on the answer given.
I hope this makes sense, but if not please let me know and I will do my best to clarify.
I may have figured it out, but if you wouldn't mind confirming for me I'd appreciate it.
Under the Condition,
YES: Create new Trello card based on answer
NO: Add a condition to check the same question for the next unique identifier in the list
Condition: question contains unique identifier [P]
YES: Create new Trello card for making pancakes
NO: Next Condition
Condition: same question contains unique identifier [E]
YES: Create new Trello card for making eggs
NO: Next Condition
In building out the flow as described, it looks as though I'm limited to 7 conditions - anything beyond that, I'm not able to choose actions for YES or NO. Maybe I'm building this out incorrectly. That being said, the question I need to create conditions for currently has 12 options and may go up to 18, so hopefully there's an answer to this that I'm unaware of.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.