Solved: The Specified record was not found/Resource not fo...

Anonymous · ‎08-23-2020

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 · ‎08-24-2020

Hi @Anonymous ,

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,

Community Support Team _ Kris Dai
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

v-xida-msft · ‎08-24-2020

Hi @Anonymous ,

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎08-24-2020

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 · ‎12-11-2020

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 @Anonymous - using the full "Close" on the app and restarting does clear it all without having to fiddle around replacing formula. Phew!

TJpaterson · ‎05-10-2021

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

Thank you

Anonymous · ‎06-08-2021

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 · ‎01-04-2022

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....😣