web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / submit form with one c...
Power Apps
Answered

submit form with one custom dropdown to SP list

(0) ShareShare
ReportReport
Posted on by 81
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!
Categories:
I have the same question (0)
  • Verified answer
    AndrianaO Profile Picture
    213 Moderator on at
    Hi! Can you refresh your data source connection and try to find the LookUp field "originele aanvraag" in your form again? I tried to recreate your problem and was able to add a similar lookup field (named "OriginalQuestion") without any problem.
     
  • Sarah_cool Profile Picture
    81 on at
    OMG I refreshed my data multiple times and now suddenly it's there!
     
    thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard