Hi @DPH
Here for building the flow I have used List A Column 'Course' is Multiline text.
Follow the below steps:
Above expression is as follows:
union(body('Select'),body('Select'))
So at this stage we have unique GUID's from List B. Next iterate all in a loop. The below all the steps are in one loop.
Above Compose 2 expression is
item()?['GUID']
Filter Array GUID is equal to map the Compose 2
Then under the Select Map expression is
item()?['Course']
Compose 3 expression is
join(body('Select_2'),outputs('Compose_4'))
Next again inside the same loop we need to filter the ListA
Above under the Filter Query map the Compose 2 output.
Next we need to check whether the value already exists or not.
Expression for the above condition is as follows:
length(outputs('Get_items_2')?['body/value'])
Then under the Create Item & Update Item I have mapped the below values:
Title: Output of Compose 2 (This field is mandatory and I need to map something here)
GUID: Output of Compose 2
Course Output of Compose 3
This is my test result
