Hi
I have a sharepoint list with a lookup column on the same list (some records can refer to others).
The look up column = originele aanvraag (original request).
Then I created a canvas app and I added a form. In the form I couldn't find my lookup column as a field, so I added a custom card to my form. That card is linked to the same data source (the SP list) but with a different name. I added a dropdown in the card where I can find the title of the other items in the list.
Then when I save the new request, I use submitform, but then the value of the dropdown in my custom card is not filled in in the SP list.
So this is the code I wrote:
SubmitForm(Form2);
Patch(
'SP List HR Manpower - aanvraag',
Form2.LastSubmit,
{
'Originele aanvraag':
{Id: DropdownCanvas2.Selected.ID,
Value: DropdownCanvas2.Selected.'Korte omschrijving'
}
}
);
ResetForm(Form2);
Navigate(DashboardScreen)
It creates a new item in the list, but the lookup column is not filled in and I really can't find the reason why.
When I do submitform, lastsubmit property is filled in with the record, so why is the patch update not working?
I really appreciate your help!
