how does one automatically bind this column with the column ID value from the previous object having focus?

Question

how does one automatically bind this column with the column ID value from the previous object having focus?

if the previous object was a list and the focus was set to a list item with an ID of 7, how does one pass that value(?ID=7;[ID]=7;@ID=7) to this dialog box?

the Member_ID column is Lookup and filtered to Members->ID; the filtering aspect works correctly once the Member_ID is set manually. The goal is to hide the Member_ID from the user and auto-fill.

please advise.

Answer 1

Hi @Luigi, 

Thank you for posting in the Microsoft Q&A forum. 

From your description, you would like to pass the ID from a previously selected list item into the Member_ID lookup column in the Add a document dialog, have that field populate automatically, and then hide it from the user. 

After checking this scenario on my side, the default SharePoint form does not automatically map custom URL parameters to list or library fields out of the box. In other words, simply adding a value to the standard form URL is not a built-in way to prefill the field. 

Based on the screenshot, this appears closer to the classic SharePoint document property dialog. In this type of form, SharePoint does not populate the Member_ID lookup field automatically from the URL by itself. The usual workaround is to pass a custom value such as ?Member_ID=7, then add client-side JavaScript on the form page to read that value, set the lookup field, and hide or disable it afterward.

If your environment is using the modern SharePoint or Microsoft Lists form experience, the default modern form does not support this type of URL-based prefilling natively. In that situation, the more suitable approach would usually involve Power Apps, and possibly Power Automate to generate or send the parameterized link.  

A Power Apps customized form can read URL parameters with Param(), for example:

If(!IsBlank(Param("Member_ID")), Param("Member_ID"), Parent.Default) 

Please note that this example helps show the concept, but because your case involves a lookup field, more specific Power Apps configuration would still be needed. 

For that reason, if you want to pursue the Power Apps or Power Automate route, I recommend posting in the Microsoft Power Platform Community, since that forum is better suited for custom form logic, query string handling, and lookup field configuration in the Power Platform.

---

As a final step, if this needs to be implemented in your organization’s environment, I also recommend contacting your IT department or SharePoint administrator and asking whether they can open a Microsoft support ticket on your behalf if needed. That can help confirm the supported approach for your specific library setup and customization method. 

• For detailed instructions on how to get support, please refer to Get support - Microsoft 365 admin.  
• In case you do not know who is your IT admin, kindly refer to this article: How do I find my Microsoft 365 admin? - Microsoft Support.  

Should you have any further questions, please feel free to reach out.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.