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

Updaing Data Source Not Working when changing fields in SPO lists

Hello,

 

I am very new to PowerApps and this is driving me nuts: I have a list for inventory equipment. One of the fields I had to modify from choice check-boxes with "allow multiple selection" to just a drop-down menu "single-selection". I went into PowerApps, unlocked the field, refreshed the data source and it still does not update the field. I even deleted it from PowerApps and closed everything. I went back, update the data source and it keeps bringing up the old field that does not exist. I even made it a required field and it still does not update in PowerApps. Need help! Very new to PowerApps.

 

Thank you,

Esteban

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Updaing Data Source Not Working when changing fields in SPO lists

Hi @Esteban2800 ,

I'm afraid that if you do not delete the form, fields in form will retain its original settings.

So I suggest you do not change your field's settings after you create the form.

Adding fields is ok, but do not change, which will lead to some problems.

 

So have my solution works for your issue?

If yes, could you mark my solution?

 

About your idea, I suggest you post it here:

https://powerusers.microsoft.com/t5/Ideas/ct-p/PA_Comm_Ideas

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Updaing Data Source Not Working when changing fields in SPO lists

Hi @Esteban2800 ,

Do you want to modify a choice column from allowing multiple selections to not allowing multiple selections?
If so, you need to do these steps:
1)change this field's setting in sharepoint list  from allowing multiple selections to not allowing multiple selections

1022.PNG

 

2)in powerapps:

refresh the connection with this sharepoint list

delete your original form

reinsert a new form for this sharepoint list

choose this choice field in this new form

check this field's datacard's Update, should be like this:

comboboxname.Selected

//for multiple choice column the formula should be like: comboboxname.SelectedItems

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I
Helper I

Re: Updaing Data Source Not Working when changing fields in SPO lists

Yes, I tried that and the only issue is that I did not want to delete the form. It is easier to delete it than to mess with it. I wish Microsoft can fix this issue. If a field is modified in an SPO list and we can refresh the data source, it should refresh it but it doesn't at all. Oh well, I guess it is easier to delete the powerapps and create a brand new one. I am a bit disappointed though. 

 

/Esteban

Highlighted
Community Support
Community Support

Re: Updaing Data Source Not Working when changing fields in SPO lists

Hi @Esteban2800 ,

I'm afraid that if you do not delete the form, fields in form will retain its original settings.

So I suggest you do not change your field's settings after you create the form.

Adding fields is ok, but do not change, which will lead to some problems.

 

So have my solution works for your issue?

If yes, could you mark my solution?

 

About your idea, I suggest you post it here:

https://powerusers.microsoft.com/t5/Ideas/ct-p/PA_Comm_Ideas

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

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 designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,198)