odd request for dropdown

(0) Share

Report

Posted on by disappointed

I have a dropdown that is populated from a SP list.

There is another list that already has some values in the column some of which might not match a value in the dropdown.

I would like to be able to compare the ThisItem value and the list of items in the dropdown and put out a message if a new selection needs to be made. The list of items in the dropdown are in a table.

Is this possible?

Thanks for looking. -Carter

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

elseb 774 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are you trying to check if the dropdown selected item exists in the sharepoint list column?

Was this reply helpful? Yes No
disappointed 90 on at

Like (0)

Report
Copy link

Link copied!

The column in SP is a single line text. I would like to use a edit form and change the data card to be a dropdown. The problem has been to get the single line text to sync up with the dropdown and display on the edit form.

Thanks for asking.

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like (0)

Report
Copy link

Link copied!

is this what you have?

dropdown with items set to:

YOUR_LIST.YOUR_TEXT_COLUMN

and the text field set to:

YOUR_DROPDOWN_NAME.SelectedText.Value

or

YOUR_DROPDOWN_NAME.SelectedText.YOUR_TEXT_COLUMN

Was this reply helpful? Yes No
disappointed 90 on at

Like (0)

Report
Copy link

Link copied!

The dropdown items list is populated from a SP list and it is displaying correctly. The dropdown has three items: "Please Select", "YES" and "No".
When I select a value from the dropdown list (i.e. "YES" or "NO") and save the form, it is updating its SP list correctly when I look at the list.
However, when I reselect this item, it does not show the selected value in the dropdown list.
I do a refresh on the datasource after the save.
The default property of the datacard is ThisItem."Update Required", the name of the field.
I have not been able to put the default on the dropdown. I get a scope error for any syntax: Value(thisitem...), thisitem.Value, thisitem.text, blah blah.
As a long shot, I tried to get the value from the gallery where I select the item but that doesn't work either.
Thank you for looking at this. I appreciate it.

Was this reply helpful? Yes No
disappointed 90 on at

Like (0)

Report
Copy link

Link copied!

Here is how I would like this to work:
1. All data selections will be in a dropdown in the powerapps.
2. The text for from that selection will be inserted in a single line text field in SP. (Works up to this point.)
3. When the row is displayed, it shows the dropdown with the data in the SP as the selected item. (Not working)

Was this reply helpful? Yes No
disappointed 90 on at

Like (0)

Report
Copy link

Link copied!

I finally figured out a solution for this. I now have the text field generated when the edit form is created. I add a dropdown to the data card and set it's default to the value of the generated form and the items from a collection created from a SP list of values. I change the update to use the selected value in the dropdown for the data card.

This does what I wanted.

Was this reply helpful? Yes No