Answered

A column I added to a collection is generating a "Specified Column does not exist" error when trying to Patch.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

First off, I am trying to migrate a form to individual fields to edit the record data from a gallery. A column I added to a collection is generating a "Specified Column does not exist" error when trying to Patch.

This is the collection code:

ClearCollect(colGNGApproval,With({StartDate: Today(),EndDate: Today() + 10// change this number},
Filter(AddColumns('Release Dashboard',

"IsChoosen",false),
Date >= StartDate,
Date <= EndDate)
)
);

I used this collection in the gallery I select from and this is the Items code:

Sort(Sort(Sort(

colGNGApproval,

'Go/No-Go'.Value,SortOrder.Descending),

'Rel Mgr'.DisplayName),

Date,SortOrder.Ascending)

Even this simplified Patch statement generate the error "The specified column 'IsChoosen' does not exist":

Patch(

'Release Dashboard',

galGNGApprovalReadiness_2.Selected,

{

'Mock Complete':ddMock_4.SelectedText

}

);

Any suggestions would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NotThe1stChoice ,

Assuming you are using SharePoint here on your Patch

Patch( 'Release Dashboard', { ID: galGNGApprovalReadiness_2.Selected.ID, 'Mock Complete': ddMock_4.Selected } );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

Wow, that does resolve the error, but I am confused as to why. The syntax of your answer is not seem to match the required entries:

Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])

Can you provide me so clarification?

Thanks

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@NotThe1stChoice ,

One of the benefits of a SharePoint Patch is the ability to include the ID and it will automatically update the relevant record.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Noted and thank you very much for the work around, but are you saying that your provided syntax is a "SharePoint only" work around? Also, any idea why my syntax was a problem?

Was this reply helpful? Yes No