The Specified record was not found/Resource not found error during patch

[muralikrishna12]

Hi Mates, 

how to resolve this issue,

I just extended column length from Varchar(50) to Varchar(500), then I refreshed SQL DataBase, the table in power apps,

removed code from the button, and re-added same code, it's not showing any error but during the running app, it throws below error.

the movement when I alter table then I am getting this error. Yes the table has already PrimaryKey mean when I create a table 

always I will use below code 

ID Integer IDENTITY(1,1) PRIMARY KEY,

do I need to reconfigure anything from the table or any what is happening when altering table?

any resolutions to fix this issue.

your help would be really appreciated 

[v-xida-msft · Accepted solution]

Hi @muralikrishna12 ,

Regarding the formula screenshot that you provided, I could not find any syntax error with it. I think this issue may be related to your SQL Table connection.

Please consider remove the SQL Table connection from your canvas app, then re-add it again in your canvas app, then within your Patch formula, re-reference the SQL Table data source, then try your Patch formula again, check if the issue is solved.

Note: When you made some changes to your SQL Table, the previous created SQL Table connection in your canvas app would be invalid. So you need to re-create a new connection to your SQL Table to make the changes take effect in your canvas app.

If the issue still exists, please consider re-type the Patch formula within your "Submit" button, then check if the issue is solved.

Regards,

[muralikrishna12]

Hi @v-xida-msft 

Thanks for your assistance, that`s right but also one more solution, which i did is close the app, and reopen then its fine. 

[TickboxPhil]

Wow, just had same error and problem after a SQL backend change and hitting Refresh in Power Apps (which should of course pick anything up, or at least warn if the whole Connection is now outdated).

Great idea @muralikrishna12 - using the full "Close" on the app and restarting does clear it all without having to fiddle around replacing formula. Phew!

[TJpaterson]

@muralikrishna12 I had the same issue posted and I just removed the data source and re added it. It worked like a charm. 

Thank you

[joybaylon_]

Hi I'm also having this kind of error on my end user. But when I opened it on my device, it seems fine. Please help me to resolve the issue.

[westerdaled]

Yep same issue here with a Power App in a solution deployed to our managed environment .  I think in our case is we have added and amended columns in our backend SharePoint list to match the list in our development site; rather than copying a blank list from dev to prod. Luckily we haven't gone live yet so there is time to fix.

One of those quick decisions that you regret tenfold afterwards....😣

Anyone found a fix for this?