Dynamics Community Forum Thread Details

Auto - Populate Field of One SharePoint List from Another SharePoint List

I have two list in SharePoint One Name is Sales Lead List and other name is Lead Interaction List in Sales Lead List I have One Column having Name Title In that I have inserted the Project name and now used these title column as a lookup in Lead Interaction List field name Lead in these Lead Field I want to auto populated the value of Title field of Sales Lead List so for that I have tried many logic and with these I developed another functionality like I make a one simple href link in Sales Lead List in each row as shown in figure

When I click on these Its move to the Lead Interaction form and these can be possible using JSON Formatting Field in Sales Lead List for Lead Interaction Link here is the Cod :-

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"attributes": {
"target": "_blank",
"href": "='https://riseascendtech.sharepoint.com/sites/SalesTeam2/Lists/Lead%20Interactions/NewForm.aspx?LeadTitle=' + [$Title]"
},
"style": {
"color": "#0078d4",
"cursor": "pointer",
"text-decoration": "underline"
},
"txtContent": "Add Lead Interaction"
}

Now after click on these I want to populate the Title value of Sales Lead List in the Lead interaction List field Lead so for that I have set a logic in Power Apps also