web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Unrecognized column wh...

Power Apps

Answered

Unrecognized column when Update Gallery field

(0) Share

Report

Report

Posted on by ehabzag

6

Hi,

I have a clone collection "OrderCollection" from "Menu" Data verse Table, with added column "Quantity"

ClearCollect(OrderCollection, 'Menu');
AddColumns(OrderCollection, "Quantity", 0);

I have a Gallery with "OrderCollection" DataSource, Quantity is visible in the Gallery.

I need to update the quantity once a button is pressed

I am using patch function

Patch(
 OrderCollection,
 LookUp(OrderCollection, ItemId = ThisItem.ItemId),
 {
 Quantity : ThisItem.Quantity + 1
 }
)

But i get the below error message:

If i use any other field, it is working perfectly, please help me and let me know what i am missing here.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ehabzag

The reason for the problem is that when you use AddColumns the new data is stored in a virtual table.
You can create a new collection to save the data after AddColumns.
Set the Gallery's Items property to the new collection.

Best Regards,

Levi

Was this reply helpful? Yes No
ehabzag 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-liwei-msft
It is now working perfectly

Was this reply helpful? Yes No

Join the conversation