cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fd00094
Helper III
Helper III

Updating excel field values to sharepoint choice column

Hello 

 

I have sharepoint list with choice column. I have cusomized that using powerapps and i have changes the items property of dropdown to have values from excel file(table, Column). I was able to populate value as per requirement but when i save the form it doesn't save excel value. It saves choices which are added in sharepoint level only.

 

Please help.

 

Thanks in Advance

8 REPLIES 8
Jagadeeshk
Resolver III
Resolver III

Change choice column setting to allow additional value than choices given

@Jagadeeshk Already updated setting at sharepoint level but still not working.

Do i need to do anything in powerapps.

 

Thanks

v-albai-msft
Microsoft
Microsoft

Hi @fd00094 ,

You should change the Update property of the DataCard from "DataCardValue26.Selected" to:

{Value:DataCardValue26.Selected.Column}

 Notes: 

1. Replace to your control name.

2. Replace to your column name. Here is an example(Activity is my Table name):

v-albai-msft_0-1617871977704.png

v-albai-msft_1-1617872001370.png

Best regards,

Allen

Hello @v-albai-msft ,

 

Tried above but still not working.

 

Thanks

Hi @fd00094 .

What is the field type in your Excel? Is it a Text field?

Does your Choice column allow multiple selections?

Please provide more information about your issue so that I can have a test on my side.

Best regards,

Allen

Hi @v-albai-msft ,

 

Field type is general it has text data, all are names.

I don't want multiple choices in choice column hence i have disabled that.

 

I can select the required value in dropdown but when i save it, it does not saves selected value. It takes choice1 added at SP column level.

 

Add values Manually is enabled.

 

Thanks

 

 

Hi @fd00094 ,

What is the Update of your Data Card - it should be

DropDownName.Selected.Value

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

WarrenBelz
Super User III
Super User III

Hi @fd00094 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (48,105)