Answered

Making changes to sharepoint list columns not updating in powerapps forms

(0) Share

Report

Posted on by Bhavpreet

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 %

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

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(5)

Report
Copy link

Link copied!

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
AjRumpel 5 on at

Like
a
(1)

Report
Copy link

Link copied!

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

God Bless you 🙂
AlbertoSP 118 on at

Like
a
(9)

Report
Copy link

Link copied!

There has to be a better way to refresh the fields then essentially, wiping out the fields and starting fresh.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(2)

Report
Copy link

Link copied!

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 127 on at

Like
a
(2)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

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.
Habib57 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for the solution.