I have a need to create a form that will collect data, optionally email someone based on the contents of that data, and put the data into a list.
My thought was MS Forms -> Power Automate Flow -> Sharepoint Online
Unfortunately, some of the questions that get asked will depend on the data that is sitting in a sharepoint list. (for example, we want a drop down of 'tags'... but need people to be able to add their own 'tag' via a text field.)
How can I 'feed' custom questions into MS forms dynamically? Should I be looking at a different product?
If MS Forms can't do this, do sharepoint 'forms' (that allow fully-dynamic content) exist in the o365 environment?
Thank you.