You’re offline. This is a read only version of the page.
I am new to this and cannot seem to solve my problem.
I have a form which I have managed to use Power Automate to put most of the data into Dataverse. What I cannot do is the dropdown menu that branches to other questions of the same name.
Question1 - Dropdown - called "Company" has branches to 2 "Clients".
Question2 - Dropdown - called "Clients" (the first of the 2 clients) - has branches to 4 "Sites"
Question3 - Dropdown - called "Clients" (the second of the 2 clients) - has branches to 6 "Sites"
Question4 - Dropdown - called "Sites" (the first of the 4 sites) - has 3 "Sites"
And so on.....
So when you go from question 1 to and it branches to either question 2 OR 3 for the "Client" answer, one of them will be blank.
It then has the same issues for "Site".
Therefore when trying to use the "Dynamic value" to connect to Dataverse then you will find many "Clients" and "Sites" that are blank.
I am unable to create a loop to remove all the blank answers and connect the remaining "Clients" and "Sites" to Dataverse.
If anyone can please help me as I have been struggling with this for 3 days trying everything with the little knowledge I have.
Thanks.
Thank you so much. You are a genius. It didn't work at first because my "empty" comparison bracket was closed at the end of the whole expression. I moved it to the end of the comparison and was singing for joy. I have it finally working on the "Clients" so now I am going to try it with the "Sites", although it is a lot more complicated.
Hi @PhilStanley
If you are able to retrieve both answers dynamically, you could use an expression IF.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (