How to run a flow from Power Apps which still runs for Blank Values in Drop downs.

[Anonymous]

Hi all,

I have a flow running from Power apps when the user presses a submit button.

There are 5 dropdowns for project choices and then 5 dropdowns for the corresponding percentage (Allocation) to each project. The user must first fill in the drop downs and select a project from each drop down, and then select the Allocation from the drop down next to it.  Now it can be the case that not all 5 are selected, therefore I set AllowEmptySelection to true so the user can just fill in selections for 3 projects for example, instead of all 5, therefore 2 dropdown boxes are left blank.

I therefore changed my formula to:

'133-TimeAllocationMasterFlow'.Run(If(IsBlank(paEmployee.Text),"",paEmployee.Text),If(IsBlank(paAllocation1.Selected.Value),"",paAllocation1.Selected.Value),If(IsBlank(paProject1.Selected.Name),"",paProject1.Selected.Name),If(IsBlank(paAllocation2.Selected.Value),"",paAllocation2.Selected.Value),If(IsBlank(paProject2.Selected.Name),"",paProject2.Selected.Name),If(IsBlank(paAllocation3.Selected.Value),"",paAllocation3.Selected.Value),If(IsBlank(paProject3.Selected.Name),"",paProject3.Selected.Name),If(IsBlank(paAllocation4.Selected.Value),"",paAllocation4.Selected.Value),If(IsBlank(paProject4.Selected.Name),"",paProject4.Selected.Name),If(IsBlank(paAllocation5.Selected.Value),"",paAllocation5.Selected.Value),If(IsBlank(paProject5.Selected.Name),"",paProject5.Selected.Name)

However, it does not accept this. The issue is with the project dropdown i.e., paProject1/2/3/4/5, not the allocation as in power automate I have allowed 0% to be accepted for the allocation.

Does anyone know how to run a flow for empty/blank drop downs.

Thanks.

[Anonymous]

Still no luck. Default is cleared, allow empty selections is set true. There is no default selected items option. Still says invalid value for the parameter left blank

[iAm_ManCat · Accepted solution]

Ok, let's look at the formula again and force text values instead of blanks where the input is a text type and a zero where its a number type:

'133-TimeAllocationMasterFlow'.Run(
If(IsBlank(paEmployee.Text), "", paEmployee.Text),
If(IsBlank(paAllocation1.Selected.Value), 0, paAllocation1.Selected.Value),
If(IsBlank(paProject1.Selected.Name), "", paProject1.Selected.Name),
If(IsBlank(paAllocation2.Selected.Value), 0, paAllocation2.Selected.Value),
If(IsBlank(paProject2.Selected.Name), "", paProject2.Selected.Name),
If(IsBlank(paAllocation3.Selected.Value), 0, paAllocation3.Selected.Value),
If(IsBlank(paProject3.Selected.Name), "", paProject3.Selected.Name),
If(IsBlank(paAllocation4.Selected.Value), 0, paAllocation4.Selected.Value),
If(IsBlank(paProject4.Selected.Name), "", paProject4.Selected.Name),
If(IsBlank(paAllocation5.Selected.Value), 0, paAllocation5.Selected.Value),
If(IsBlank(paProject5.Selected.Name), "",paProject5.Selected.Name),
If(IsBlank(paComments.Text),"",paComments.Text),
User().Email
);
Navigate(Thankyou,Fade);

Then in your flow just make sure to check for if inputName is equal to (and then leave the right box blank) for each input and perform actions accordingly

[Anonymous]

IT WORKED!!! Thank you so much for your time and patience, much appreciated! Amazing @iAm_ManCat 

[iAm_ManCat]

Glad we got it sorted in the end 🙂