cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ubikwitous
Level: Powered On

Flow with multiple IF statements, based on PowerApp DropDown

I have a PowerApp with a dropdown menu called CustomerDropDown, containing customer names. Based on which customer is selected, I am calling a Flow to insert a new row into an Excel table with the following:

Date (using utcNow), Customer Name (just passing the CustomerDropDown.Selected.Value), and I'm trying to get a mileage and toll value passed. 

 

The mileage and toll would be IF CustomerDropDown.Selected.Value = "customer1", then write 100 to that column.

 

I'm not sure what to put in the blanks or if it is easier to somehow set the variables in PowerApps and pass them. Thanks!

 

Flow.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
ubikwitous
Level: Powered On

Re: Flow with multiple IF statements, based on PowerApp DropDown

I figured this out. I added a step to Get rows before the Add a row where the variables are called and match it via the Key Value from the PowerApp. Hopefully this helps someone!

 

Capture2.PNG

View solution in original post

2 REPLIES 2
ubikwitous
Level: Powered On

Re: Flow with multiple IF statements, based on PowerApp DropDown

I took a bit of a different tactic and created a table for the dropdown. The table has 3 columns, but intentionally only the first shows up.

 

Customer    Mileage    Tolls

 

I'm now trying to figure out how to pass the Mileage and Tolls to the Flow from the data table in the PowerApp. Is there a way to do this or do I need to connect the flow to the data table?

ubikwitous
Level: Powered On

Re: Flow with multiple IF statements, based on PowerApp DropDown

I figured this out. I added a step to Get rows before the Add a row where the variables are called and match it via the Key Value from the PowerApp. Hopefully this helps someone!

 

Capture2.PNG

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,539)