| ID | Name |
| A1 | ABC |
| A2 | ABCD |
| Name | Account | Amount |
| Name | Account | Amount | ID |
| ABC | A1 | ||
| ABCD | A2 |

| ID | Name |
| A1 | ABC |
| A2 | ABCD |
| Name | Account | Amount |
| Name | Account | Amount | ID |
| ABC | A1 | ||
| ABCD | A2 |
ForAll(
SharepointList1 As List1,
Collect(
colCombinedList,
{
Name: List1.Name,
Account: LookUp(SharepointList2, Name = List1.Name).Account,
Amount: LookUp(SharepointList2, Name = List1.Name).Amount,
ID: List1.ID
}
)
)