cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bhavpreet
Level: Powered On

Making changes to sharepoint list columns not updating in powerapps forms

Hello,

 

I have a SharePoint list for which the form was cutomized using PowerApps. After creating the form, I made some columns mandatory and updated their names. These changs aren't reflecting in my form. I have tried refreshing the data but the column stayed as is and the star does show up.

 

There are only 2 ways, not very efficient that I figured out:

- Unlocking the Data Card and make the changes.

- In the field list, change the data card view, e.g. from Edit number to %

Powerapps.PNG 

 

 

 

 

 

 

 

 

 

 

 

With either of the 2 approaches, I have to readjust the font size etc. Is there any easier way of achiving the same?

 

Thank you.

Bhavpreet Bains

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Making changes to sharepoint list columns not updating in powerapps forms

Hi @Bhavpreet,

 

I just tested in my custom form with the same thing you did. And I'm able to fix this following below steps:

1. With the form selected, in the Fields tree view on the right side, uncheck this column's data card to delete it from the form.

2. Refresh the data source.

3. Then you could see in the tree view that the column name is updated. Check this column's data card to add it back. You will see the new name is shown there and the "*" that means it's required field is there too.

 

Regards,

Mona

Community Support Team _ Mona Li
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

7 REPLIES 7
Community Support Team
Community Support Team

Re: Making changes to sharepoint list columns not updating in powerapps forms

Hi @Bhavpreet,

 

I just tested in my custom form with the same thing you did. And I'm able to fix this following below steps:

1. With the form selected, in the Fields tree view on the right side, uncheck this column's data card to delete it from the form.

2. Refresh the data source.

3. Then you could see in the tree view that the column name is updated. Check this column's data card to add it back. You will see the new name is shown there and the "*" that means it's required field is there too.

 

Regards,

Mona

Community Support Team _ Mona Li
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

AjRumpel
Level: Power Up

Re: Making changes to sharepoint list columns not updating in powerapps forms

Mona - 5 hrs searching Google and I finally stumbled across your post.

 

God Bless you 🙂

AlbertoSP
Level: Powered On

Re: Making changes to sharepoint list columns not updating in powerapps forms

There has to be a better way to refresh the fields then essentially, wiping out the fields and starting fresh.

Anonymous
Not applicable

Re: Making changes to sharepoint list columns not updating in powerapps forms

Is there? because I am facing the same problem and the solution posted above is not working for me

Don_L
Level: Power Up

Re: Making changes to sharepoint list columns not updating in powerapps forms

The work around on this issue to refresh your fields from a sharepoint list is as follows:

 

1.  Save and Close everything all PowerApps tabs open in Chrome or whatever browser you're working on save and close

2.  Log into/go to  your sharepoint list

3.  Select an item to edit in your sharepoint list

4.  When your edit view opens up select "Customize in PowerApps"

5.  Then select your SharePointForm1

6.  Edit Fields 

7.  Select Add Fields and you will see the new fields and the field updates you made to the SP List

 

This reload the entire PowerApps processes and brings over the new/updated columns.  Using the data refresh is useless.  My guess is I believe PowerApps is persisted in Dynamics 365 and when those connections are made you literally have to stop and save what you're doing and essentially reboot to see the new changes.  The info must be cached in dynamics somehow.

 

Hope this helps

ahohman
Level: Powered On

Re: Making changes to sharepoint list columns not updating in powerapps forms

This is not working for me either.  I had to change a field from a Date Type to a Single Line of Text.  I de-selected the fields in the PowerApp form and published to SharePoint first.  Then made the field change.  Opened back up in PowerApps, and the fields are still Date Type, but in SharePoint they are Text.  I have no idea what to do.  Really frustrating.  

csobsidian
Level: Powered On

Re: Making changes to sharepoint list columns not updating in powerapps forms

1. Select your EditForm in your Power App.

2. Change the data source from your existing data source to another. Create an empty collection if no other source is available. Do not worry about your data cards having error messages.

3. Set the data source back to the original data source. This will force a refresh of the data source definition.

4. Select "No Thanks" when asked if you would like to replace your data cards.

You should now be able to edit your fields with your modified data types from share point.

 

Edit: typo.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,068)