Change Drop Down Items Value by selected List Item from a SharePoint List

[Saintenr]

Hello Guys, 

I want to create a PowerApp which writes data to a SharePoint list via dropdown menu and which can then be reloaded and edited with the PowerApp. I did the writing to the SharePoint list with a patch, because written records should not be changed. So writing is no problem. When loading the data, the user should get a list on the start page where his created entries, from the SharePoint list are displayed. This was verified by name matching of the logged in user.

So much for what has been achieved so far.

The problem is that I haven't yet figured out how to write the data from the SharePoint list as value into the corresponding dropdown fields based on the selected list entry on the start page.

Can you help me there?
thank you very much,
Saintenr

[RandyHayes]

@Saintenr 

Can you describe more about what you expect to have in the DropDown list?  Is it a Filter of a column in your SharePoint list, or a Filter based on a condition?  What values are you expecting to have in your DropDown?

Also, if you have any sort of information about your SharePoint columns that would be helpful to know, share that as well.

[Saintenr]

Hello,

the table type is Single lines of text. I could now read the value with "Set(VarLocationKey;listmyList.SelectedItems.'my Item');;". So, based on the value selected in the table on the start page. I can also set the value as dropdown default value. I would like to add the M
Have the opportunity to change the value. For example {op1, op2, op3,...}. Is this possible? Also I come to the error that if I want to set the read out value into a text field as default value, a table value and no text value will be output.

Thank you, Saintenr

[v-xida-msft · Accepted solution]

HI @Saintenr ,

How do you list your SP list reocrds within your start page? Using Gallery or Data Table or List box?

Could you please share a bit more about your app's configuration?

Further, do you want to change the Items value within your Dropdown box based on the selected entry within your Start page?

Based on the needs that you mentioned, I think the Filter function could achieve your needs. Please take a try with the following workaround:

Set the Items property of the Dropdown box to following:

Filter(
        'YourDataSource',
         FilteredColumn = listmyList.Selected.FilteredColumn
)

Note: The FilteredColumn represents the column you want to use to filter your SP list records based on the selected in your Start page.

More details about Filter function, please check the following article:

Filter function

Best regards,