Unanswered

My PowerApp Won't Allow me to modify data in the SQL Database

(0) Share

Report

Posted on by PowerAppsUser10

Hey Everyone,

I am able to save (create a record) to the SQL database, however I am not able to modify a record. I have used every arrangement of code inside and outside of my gallery and can't seem to get it to work consistently.

The most popular error is The requested operation is invalid. Server response: _scrubbedSensitiveData_.

Can anyone help with this or suggest a code that is working for them?

That error is there at all times once I'm trying to modify a record in the database. I am using SQL connections and on-premise gateway.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerAppsUser10

This is clearly a caching issue.

Refresh SQL connection will fix the issue but sometimes not.
Remove and Add it back
Please remove the SQL Connection
Clear the cache
Close the app and Reopen it
Add the SQL connection back
Make sure Table has an Identity column

I had this issue yesterday. 😀

Was this reply helpful? Yes No
PowerAppsUser10 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey StalinPonnusamy

Thank you for your Response.

1. Did you have issues modifying the records in sql using powerapps? and was the scrubbedsensitivedata your only issue?

2. Could you send me the code you used to modify the data. Was it a button outside the gallery.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerAppsUser10

I had an issue with the insert itself. But the issue is the Schema difference between SQL and PowerApps
SQL Collect Statement
ClearCollect( tempTable, { RoleID: 1000, FactName: "TEST1" }, { RoleID: 1000, FactName: "TEST2" }, { RoleID: 1000, FactName: "TEST3" } ); Collect( RoleFact, tempTable )

Was this reply helpful? Yes No
PowerAppsUser10 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey StalinPonnusamy

Inserting is good for me. Modifying what I have saved is not working at all.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerAppsUser10

I just tested and the Individual patch command works.

Patch( RoleFact, { RoleFactID: 4, RoleID: 2000, FactName: "TEST" } )

Note: RoleFactID - Identity Column

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerAppsUser10

ClearCollect( UpdateTable, { RoleFactIDNew: 4, RoleID: 1001, FactName: "TEST10" }, { RoleFactIDNew: 5, RoleID: 1002, FactName: "TEST11" }, { RoleFactIDNew: 6, RoleID: 1003, FactName: "TEST12" } ); ForAll( UpdateTable, Patch( RoleFact, { RoleFactID:ThisRecord.RoleFactIDNew, RoleID: ThisRecord.RoleID, FactName: ThisRecord.FactName } ) )

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerAppsUser10

Please let us know if anything needs on your post. We can help with this.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No