cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PhilStanley
Helper I
Helper I

Remove blank answers from Forms

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.

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Community Champion
Community Champion

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

View solution in original post

2 REPLIES 2
DamoBird365
Community Champion
Community Champion

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

View solution in original post

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.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,355)