Answered

Pulling Value from Sharepoint List - Driven Dropdown

(0) Share

Report

Posted on by PBGIT

Hey all,

I'm working on building a HR management application. The idea is that the user can pick from a name from a dropdown that contains a list of names (which is pulled from/connected to a SharePoint List), then click a button at the bottom of the screen. The button will communicate with MS Flows to scan the associated SP list for the name and move it to an archive list.

I have already figured out connecting PowerApps to Flows and vice versa, however, I'm getting stuck at what seems to be the finish line here. In all the tutorials/examples I followed, the instructor uses a Text box instead of a dropdown and simply sets something like PowerAppsbutton.Run(TextBox.Text) as the formula for the trigger button. As I'm using a dropdown, I simply altered that to PowerAppsbutton.Run(Dropdown.Selected). However, this is returning an error. I have already tried Dropdown.Selected.Value and Dropdown.SelectedText.

It seems that a Dropdown pulled from a SP list behaves differently than one built directly into the app itself. I am wondering how to force PowerApps to recognize the selection that the user chooses from the dropdown so that I can then use that in the flow.

I've attached an image of what I'm working with.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

kunalkankariya 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Dropdown.SelectedText is a "Record". You should be able to select a specific field like "Dropdown.SelectedText.FieldName'.

Can you please try?

Regards,
KK
Please accept this as a solution and hit the like button if this did help. Thanks 🙂

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PBGIT ,

Do you want to know how to use drop down selected value in your trigger flow formula?

That is decided by two things:
1)what kind of parameter that your flow needs

Please check whether your flow needs a table, a record or a string.

You need to use different formula based on different kinds of parameters that flow needs.

2)the drop down's Items? the field data type that you want to use ?

You need to use different formula based on the items of the drop down to represent the data that you want.

I assume that the flow need a string, the drop down's Items is a common table, you want to get a text field value.

Then you need to use formula like this:

PowerAppsbutton.Run(DropDown2.Selected.fieldname)

I assume that the flow need a string, the drop down's Items is a table like this: [...,....], you want to get a text field value.

Then you need to use formula like this:

PowerAppsbutton.Run(DropDown2.Selected.Value)

I assume that the flow need a string, the drop down's Items is a table like this: Distinct(...), you want to get a text field value.

Then you need to use formula like this:

PowerAppsbutton.Run(DropDown2.Selected.Result)

I assume that the flow need a record, the drop down's Items is a table , you want to get selected record.

Then you need to use formula like this:

PowerAppsbutton.Run(DropDown2.Selected)

Please show me more details.

Best regards,

Was this reply helpful? Yes No