web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Renaming SQL Field and...
Power Apps
Unanswered

Renaming SQL Field and Connecting to Data in PowerApps

(0) ShareShare
ReportReport
Posted on by 8

UPDATE: I got it to work and can confirm i have fixed it and the entry is now submitting without error.  Under the "Advanced" when editing fields there is another location to update your fields.  So you are essentially updating the text in 2 places, though it feels like 4 places....... Yay! 

 

Hello, I may or may have messed up.... see what i did there.

 

We renamed our campaign and focus and to keep things simple (at the time it seemed smart) rather than creating new fields in SQL, I edited and overwrote the previous fields in the SQL.  I refreshed the data in PowerApps and was faced with an overwhelming amount of errors.  I was able to correct the errors by renaming the "card:" and the "fX " accordingly.  It was tedious.  Everything looks good and seems to be working great until I submit an entry and receive the error "The requested operation is invalid.  Server Response: A value must be provided for item. clientRequestId:5173b771-6d54-49ea-b093-feb51bc082d0"   

 

I noticed that when i click on one of the cards in the i created, it's showing the previous SQL field.  But I cannot find where to edit this "Card : 10.GDPermits"  See image i've attached.  Thank you PowerApps Community.  Hoping for the best. Power Apps Submit Error.png

Power Apps Submit Error.png
Categories:
I have the same question (0)
  • mogulman Profile Picture
    764 on at

    I had the case I had to rename a bunch of columns.  I issued a lot of commands in SSMS.

     

    EXEC sp_rename 'dbo.Matter.SSAUploaded', 'SSAPUploaded', 'COLUMN';

    I refreshed the table in PA and  had a lot of red x's.  I deleted all the fields with a red x and added in the renamed field.  Very tedious.  If you unzip the PA file and look at the JSON you'll see why you need to do it this way.

  • raheelr Profile Picture
    19 on at

    I would say go into 'Edit' Field; Remove the field and re-add.

    I find sometimes i have to close the app in designer and re-open to see some changes.

  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @sheshe 

    Do you mean you have found out the workaround?

    Could you please share/ post the workaround and accept it as the Answer to help other members find it more quickly?

    Sik

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard