Showing results for 
Search instead for 
Did you mean: 
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 

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

Helper I
Helper I

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


Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,537)