Error in running Patch function

(0) Share

Report

Posted on by IMathur

291

Hi Folks,

Below is the message that i am getting while using the patch formula,

I already have the 'AccessToCopiedFolderLocation" column in changepoint sharepoint list.

and because of this patch function is not able to run.

Please help!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
When doing any kind of comparison using 'or' you need to repeat the whole comparison. So instead of

ProjectStatus.value = "Completed" || "Not Won"

you should be using

ProjectStatus.value = "Completed" || ProjectStatus.value = "Not Won"

Was this reply helpful? Yes No
IMathur 291 on at

Like (0)

Report

Hi @Pstork1,

It is still there:
, there is a gallery in the app, using this filter, with the gallery also, it is showing the same error:

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Since the error is referring to a column that isn't used in the formula I suspect you've changed something in the data source since you originally made the connection. If so then you need to either refresh the data connection or delete it and recreate it. I'm assuming there was a column with the name in the error at one point in time, but that the column no longer exists.

Was this reply helpful? Yes No
puluthra Microsoft Employee on at

Like (0)

Report

try ~~Remove~~DropColumns(changepoint, "AccessToCopiedFolderLocation")
or
ShowColumns(changepoint, ID, xyz) //show ID column and the columns you need to patch
before you use the collection in Patch.

If the column exists in your data source then its best to re-add/refresh the data source. Sometimes I need to re-open the powerapps editor.

Was this reply helpful? Yes No
IMathur 291 on at

Like (0)

Report

Yes @Pstork1 , I added this column, after i created the link of the list in the app, but now i have removed the list and added it again, it is still giving this error

Was this reply helpful? Yes No
IMathur 291 on at

Like (0)

Report

Hi @puluthra ,

Please see the image below, i have this column in data source list:

Was this reply helpful? Yes No
IMathur 291 on at

Like (0)

Report

Hi @puluthra ,

Please see the below error in Remove function and help on this:

Was this reply helpful? Yes No
Verified answer

puluthra Microsoft Employee on at

Like (1)

Report

@IMathur I meant DropColumns (corrected syntax in my previous post, my bad). The idea is to remove/drop the columns from your collection that do not exist in your data source and try.
In your case since the column exists and you're still seeing this error, I would try removing the data source from the app, save, close the powerapp and re-open it in the designer, and then re-add the data source. I ran into this issue where powerapps wasn't recognizing the newly added fields and reloading the app fixed the problem.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

Did you save and close the app after removing the data source? If not its probably retaining the reference to the original Schema. What type of data source is it? SharePoint, CDS, SQL, or something else? For some of the data sources you can use the context menu on the data source connection list in the app to Refresh the data source. That will pick up the new schema.

Was this reply helpful? Yes No