Unanswered

Passing PowerApp cascading dropdown selected value to Flow

(0) Share

Report

Posted on by Community Power Pla...

I have a Sharepoint list which I created cascading dropdown using PowerApps. However, when I try to save the list and trigger the flow, the selected value of cascading dropdown cannot be passed to the flow.

For the list, Expense Item is the cascading dropdown based on the value in Nature field.

I don't want the people to click a separate "Save" button in PowerApps other than the default save button on the top of the list. So my question is how to get my cascading dropdown selected value to flow?

Thank you.

Categories:

Building Power Apps

Screen Shot 2020-...

I have the same question (0)

All responses (10)

Answers (0)

eka24 20,923 on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

What is your current formula that is not working for you.
Try any of these:
FlowName(DropDown1.Selected.Value)
FlowName(DropDown1.Selected.Result)
FlowName(DropDown1.Selected.ColumnName)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @Anonymous :
Could you tell me :
What is the drop down control's items property?
What is the Value property of this drop down control?
I assume that this dropdown control is set as follows:
Items:

Choices(yourdatasource.'Expense Item')

Please add a button and set it's OnSelect property to:

FlowName.Run(Dropdown1.SelectedText.Value)

Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

@v-bofeng-msft
I can't find the value you mentioned above but I captured these for you.
Company Payment Form is the list name and the data source is an excel Table1.

Is it possible to not add a button? Can't I just click the 'Save' button on the list and get the PowerApps data?
The save button on the top

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @Anonymous ：
Please put this code into the OnSave property of SharePoointIntergration.

FlowName.Run(DataCardValue12.Selected.ExpenseItem);Submitform(SharePointForm1)

Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @v-bofeng-msft
Thank you for your reply. I think it works because the PowerApps did not show any errors.
However, the flow isn't work for some reasons.
I created a new item in Sharepoint but the flow just does not run at all.
I am wondering if I set my flow incorrectly. Could you please help?
Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @v-bofeng-msft

I tried to run the flow by itself for testing but it shows this dialog box.
Is it normal?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @Anonymous :
this is normal. Because you chose "I'll perform the trigger action".
Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @v-bofeng-msft

Thank you for your reply.
Could I ask why my flow doesn't work then?

The flow is not even kickstart when I create a new item in the list.

Thank you.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @Anonymous :
I'm afraid you can only have one trigger in a flow.
I think this link will help you a lot:
https://powerusers.microsoft.com/t5/Using-Flows/Using-two-triggers-after-each-other-in-one-flow/td-p/199811
Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Passing PowerApp cascading dropdown selected value to Flow

Hi @v-bofeng-msft
Thank you for your information. I didn't know that.
I just came up with a workaround solution.

I removed external excel data source and I will add two dropdown boxes in the list, Expense item (Admin) and Expense item (Project).
When the user choose 'Admin' in Nature dropdown, the section Expense item (Project) will hide and the Required=false.
While when the user choose 'Project' in Nature dropdown, the section Expense item (Admin) will hide and the Required=false.

Is it possible to archives in PowerApps?
Thank you!

Was this reply helpful? Yes No