Answered

Remove blank answers from Forms

(0) Share

Report

Posted on by PhilStanley

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.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PhilStanley

If you are able to retrieve both answers dynamically, you could use an expression IF.

if(empty('Answer2-1'),'Answer2-2','Answer2-1')

So if answer2-1 is empty, use answer 2-2 otherwise use answer 2-1.

Does that help?

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

Was this reply helpful? Yes No
PhilStanley 34 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No