Parsing/moving data to a form

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3143106%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EParsing%2Fmoving%20data%20to%20a%20form%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3143106%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20(Table%202)%20that%20opens%20filtered%20by%20a%20Reference%20field%20from%20the%20hyperlink%20when%20the%20user%20clicks%20a%20field%20in%20Table%201%2C%20like%20this%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%20data-unlink%3D%22%5C%26quot%3Btrue%5C%26quot%3B%22%3Ehttps%3A%2F%2FX123.sharepoint.com%2Fteams%2FPROJECT%2FLists%2Ftbl_Update%2FAllItems.aspx%3FFilterField1%3Dassignment%255Tx0030%258Fitem%26amp%3B%3CSTRONG%3EFilterValue1%3D4%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIn%20this%20case%20the%20Table%202%20is%20opened%20filtered%20based%20on%20value%204.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20want%20users%20to%20add%20new%20items%20to%20Table%202%20using%20value%204%20(or%20any%20other%20value%20in%20the%20filter).%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIs%20there%20a%20way%20to%20prepopulate%20the%20new%20item%20form%20so%20that%20one%20of%20the%20fields%20is%20populated%20with%20the%20value%20in%20the%20filter%3F%26lt%3B%5C%2FSTRONG%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20kinda%20hoping%20for%20some%20JSON%20code%2C%20but%20any%20solution%20will%20do.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ELeo%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3143106%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3ESharePoint%20Online%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Contributor

Hello,

 

I have a list (Table 2) that opens filtered by a Reference field from the hyperlink when the user clicks a field in Table 1, like this:

 

https://X123.sharepoint.com/teams/PROJECT/Lists/tbl_Update/AllItems.aspx?FilterField1=assignment%5Tx0030%8Fitem&FilterValue1=4 

 

In this case the Table 2 is opened filtered based on value 4.

 

I want users to add new items to Table 2 using value 4 (or any other value in the filter).

Is there a way to prepopulate the new item form so that one of the fields is populated with the value in the filter?

 

I'm kinda hoping for some JSON code, but any solution will do.

 

Thank you very much

Leo

 

0 Replies