Answered

Dropdown selected Item makes appear in other Dropdown the column in Sharepoint List having name like this Selected item

(0) Share

Report

Posted on by Bastos

Hello,

I have 2 Lists in SharePoint. See attached images . In my Form, I want to appear in Dropdown "Type d'Achat" the column which name is the selected Item in Dropdown "Service Acheteur".

Please Help!!!

Best Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

JatinSaini 428 on at

Like (1)

Report
Copy link

Link copied!

Hi @Bastos ,
Let me know if am correct, you want your Dropdown "Type d'Achat" to be updated with the items of that field whose name is selected from the Dropdown "Service Acheteur"?

If you are selecting - "Interne_ITL_Cellule_ITL" then the dropdown should show the items for that column?

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Bastos ,

We made a sample for you.
OnChange:
ClearCollect(Col3,Dropdown2_1.Selected)

Items of another DropDown:
Col3
Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Bastos on at

Like (0)

Report
Copy link

Link copied!

Yes.

Was this reply helpful? Yes No
Bastos on at

Like (0)

Report
Copy link

Link copied!

Hi,
It is very simple if like this. SharePoint List column names in "Type-Achat" are Items for the List "Service Acheteur". So The Dropdown "Type d'Achat" becomes variable. It depends on Selected value in "Service Acheteur" Dropdown.
Best Bastos

Was this reply helpful? Yes No
JatinSaini 428 on at

Like (0)

Report
Copy link

Link copied!

On the second list for which the image you shared, it's visible that the names are under the Title column.
If that's true, then use the dropdown formula to filter the list by dynamically providing the title value.

Dropdown Items -
Filter(DataSource_List, Title=Service_Acheteur.Selected.Value,ChoiceColumn_Name)

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Bastos ,
Actually, they are same between them.

We made a SharePoint List to be data source for you.
First Dropdrown:
Items:
DataSource.ColumnName
OnChange:
ClearCollect(Col3,Dropdown2_1.Selected)

Second Dropdrown:
Items:
Col3
Value:
"Title"

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No