Any thoughts on constructing a flow to display the contents of a dynamic list read from excel or SQL and using it as user input selections ie client -> project -> task
Could you please show a bit more about the Dynamic list that you mentioned? Is it a SharePoint list?
I assume that the Dynamic list that you mentioned is a SharePoint list, I think the "Get items" action of SharePoint connector could achieve your needs.
If the Dynamic list is a SharePoint list, you could consider extract data from the Excel table or the SQL table and store them in your Dynamic list (SharePoint list) which has been defined within your SharePoint firstly. Then use the "Get items" action of SharePoint connector to get items from the Dynamic list.
I have made a test on my side and please take a try with the following workaround:
You could use the output of the "Get items" action as the input selection within next step.
If you could provide more details about your scenario, we would provide a proper workaround for you.
Thanks Kris - appreciate the workaround.
Ultimately what I would like to do is use the dynamic list in my trigger. I use a manual trigger and request user input through the use of radio buttons. The configuration for the radio buttons appears to be fixed to the static tags that I enter in the trigger configuration for use input I am looking to make the drop-down list of options to be the dynamic list. I am looking to read a dynamic list of projects from excel (which I have done) and allow the user to select the project when the flow is triggered. I am trying to populate the drop down list of options with the items in the dynamic list.
Ditto! I want to have, within my trigger, a dropdown that pulls from a list of clients. I need the user to pick a client name from that dropdown and then input the hours they worked on that client. I can't seem to figure out how to make the dropdown list in the trigger be tied to my sharepoint list of clients. Grrrr! Any help would be appreciated. Perhaps I am going about this process in the wrong manner?
I would also be very interested in knowing if anyone has found a solution to your question? Having dynamic inputs would make our manual triggered flows significantly more useful.
I would love to know the answer to this too. I'd like to have the user trigger the Flow with a button, then choose from a dynamically populated drop down list. This drop down could be done using "Post a choice of options as the Flow bot to a user". Are there any other suggestions for how this could be achieved?
Same Thing here. The documentation on the dynamic lists is "lacking" if I am being polite, and not having this additional information from Microsoft is really reducing the value of my triggers.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.