Lesson121 - Join SharePoint Lists Data - Power Automate 1000 Videos

[@PowerAutomateVideos]

Join SharePoint Lists Data
Create list
List3
Title
FirstName
Enter Data
1 intekhab
2 Nikhil
List4
Title
FirstName
Enter Data
3 Anne
4 Mike
Create Flow
Instance Cloud flow
Flow_CombineLists1
Add Step
Initialize variable
varReturnJSON
string
Add Step
Initialize variable
varFinalJSON
string
Add Step
Initialize variable
varItemJSON
string
Add step
sharepoint
Get items - List3
select communication Site
list3
Add step
Apply to each - List3
value
from Get items - List3
Set variable - varitemjSoN list3
varItemJSON
{
"List" : "List3",
"Title" : "@{items('Apply_to_each_-_List3')?['Title']}",
"FirstName" : "@{items('Apply_to_each_-_List3')?['FirstName']}"
}
For right hand site pick Title form Get items - List3
Add step compose - list3
concat( variables('varFinalJSON'),' , ' , variables('varItemJSON'))
set variable
varFinalJSON
select outputs from Compose - list3
Copy Get items - List3 to clip board
Add step paste from clip board
rename
Get items - List4
change list name to List4
Copy step apply to each - List3
and paste it and name to apply to each - List4
value - select from Get items - List4
rename to
Set variable - varItemJSON list4
Change Title and FirstNaame to pick from Get items - List4
Set variable - list4
change to Outputs from Compose - list4
Set variable varReturnJSON
concat( '[' , substring(variables('varFinalJSON'), 2, sub(length(variables('varFinalJSON')),2) ), ']')