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 / Patch a vlookup ID cou...
Power Apps
Answered

Patch a vlookup ID coulmn in Sharepoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

 

I'm pretty new in Powerapps, I created a Sharepoint List called "Overview" that has a 'Request ID' indexed column.
I also created "Order" contains vlookup to 'Request ID' in Overview list.

How do I vlookup ID from Overview to Order list After submit a form which generated from 'Order' list?

Note that the 'Request ID' is a lookup column to 'Request ID' in Overview list and not show in form.

Any help would be appriciated

Categories:
  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Do you mean that :

    1)Overview list:  'Request ID' (number type)?

    2)Order list:  'Request ID' is a lookup column(looks up to 'Request ID'  in Overview list)?

    Could you describe more clearly about this sentence: "How do I vlookup ID from Overview to Order list After submit a form which generated from 'Order' list?"?

    I do not quite understand the meaning of "vlookup".

    I suggest you list an example to describe.

    Showing  screenshoot about this issue will also help a lot.

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @v-yutliu-msft ,

     

    Thank you for your response.

    I have a Overview Sharepoint list which contains Request ID column (indexed column)

    I created an form to input information to Order list which has lookup column Request ID (lookup to Request ID column in Overview List).

    Currently, when I click the submit button, a record will be created in Overview list with a Request ID and the information of form all input into Order list.

    The thing I want to archive here is fill the corresponding Request ID in Overview list to Order list?

     

  • Verified answer
    v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Do you mean that:
    1)you use this form to create a new item in  Order list(without  Request ID column)?

    2)after you update Order list, you create a new item in Overview list with the form's data?

    3)after you update Overview list, you will update Request ID column in Oder list with the related Request ID column in Overview list?

    If so, I suggest you use this formula in your submit button's OnSelect:

    SubmitForm(Form1);
    Patch(Overview,Defaults(Overview),{....});
    //the data that you want to update Overview list
    Patch(Order,Last(Order),{'Request ID';:{Value:Last(Overview).'Request ID',Id:Last(Overview).ID}})

     

     

     

    Best regards,

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard