Hello,
I have a power app which contains a form that creates new items in a Sharepoint list. It has a few columns including one which is a lookup to a different list.
This all worked fine. However when I added a second column in the lookup list, which i used to sort in the combobox, my form doesn't submit as expected anymore.
Now, all my columns are filled in except the lookup one. I've checked everything and it should work. When I use the monitoring tool I've discovered that the lookup column value is included in the 'patchcreaterow' operation, but NOT in the 'createrow' operation. All the fields (id, title, new column added ...) are filled in fine in the net payload of patchcreaterow. In createrow it's dissapeared.
Does anyone have a suggestion what the cause can be? Is this a bug? The datacardvalue is set up correctly, as is the datacard and the form. It should work. It just doesn't after adding a second column in the lookup.
Thanks