You’re offline. This is a read only version of the page.
34
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
WarrenBelz
146,547
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
