cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MAM627646
Helper I
Helper I

Storing the data selected from dropdown list to sharepoint list

Hi guys,

I have a dropdown list that gets the data from an excel sheet . This dropdownlist is part of a form that store the data in Sharepoint list. 

The items field on the dropdown list is set to Filter(DepartTable,Lan=setLanguage).Depart. 

The Update field on the Department card is set to DataCardValue8_1.Selected.

 

The forms submit and save the whole data in the sharepoint list except for this drowndown list. Am attaching herewith snapshots of the fields for easy reference .

Most grateful for your support and assistance 

3 REPLIES 3
CNT
Super User
Super User

@MAM627646 Does the type of the Depart column in the DepartTable and the type of the Department column in your SP List match?

Thanks much for your prompt response. 

The type is set to choice in sharepoint list . As for the dropdownlist , the choices are populated from excel sheet

MAM627646
Helper I
Helper I

I resolved my issue thanks. The Department card Update should be set to

 {
Value:
DataCardValue8_1.Selected.Depart}

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,052)