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

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
Highlighted
Community Support
Community Support

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

11 REPLIES 11
Highlighted
Community Support
Community Support

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

Highlighted

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

 

God Bless you 🙂

Highlighted

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

Highlighted
Anonymous
Not applicable

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

Highlighted
New Member

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

Highlighted

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.  

Highlighted

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.

Highlighted

Good idea but it didn't work for me...... It kept the layout which was good but I have had to change all of the names of the Thisitem. fields to match the new SharePoint column names. 

Highlighted

Okay, that was my mistake. I just noticed the original post also dealt with changing column names. I don't think there is ANY way to avoid manual fixes on your data cards if you change the column name itself. However, if your issue is related to any of the other properties of a column (data type, required, etc.), then my method above should work.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,193)