Dear Community,
I have created a grid view for my app. However, I tried to change the settings, so it displays the values based on a code from another list (Parent child logic).
So both lists are "connected" through a code assigned.
1 item can have multiple costs, thus:
- list 1 (Parent list): will show the item info and the sum of all costs
| Code | Item | Cost |
| 0001 | Chocolate | 5 |
| 0002 | Shirt | 10 |
- list 2 (child list): should show or have all costs related to one item o many but all of them are based on code
| Code | Item | |
| 0001 | Chocolate | 2.5 |
| 0001 | Cholate | 2.5 |
| 0002 | Shirt | 5 |
| 0002 | Shirt | 5 |
Then I got problems when trying to create a new line of costs for the code/item for list 1. I get a message saying "network error when using patch function: the specified column is generated by the server and can't be specified powerapps"
in the Items of List 2: Sort(Filter(ColGridDataCal,'Proposal ID' = DataCardValue3_1.Text),ID,Descending)
and I get problems with the Patch of "edit in grid view" button.
As a refence, I followed the instruction in Reza Dorrani video https://www.youtube.com/watch?v=wI6SHGQ9ATg&list=PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU&index=2
But I change the filter of the gallery to show a based on code, now I cannot create new items, it gets an error.

Report
All responses (
Answers (