Answered

Intersection Expression Showing Blank on Input

(0) Share

Report

Posted on by bsmith736464

I have build a flow where I am looking to compare two array variables but when I run the intersection expression, it appears that the input and output are both an empty array. I don't understand how it is possible but any help would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @bsmith736464 ,

This shows that these two collections do not have common items.

Best Regards,

Wearsky

Was this reply helpful? Yes No
NaufalP 75 on at

Like (1)

Report

Hello!
I know this is an old thread but wanted to revive this since I'm facing similar issues. I have to 2 arrays of objects variable with the same key in both of them, one is generated by excel and one is from sharepoint.

When I used the intersection expression it return an input and output of empty..
Is there something I'm missing? I've been trying to figure it out for days.

Var 1
Var 2

Intersection Action
intersection(variables('var_IDSPO'),variables('var_IDEXCEL'))

Was this reply helpful? Yes No
Priddo 6 on at

Like (0)

Report

Hi NaufalWahika, did you get anywhere on this? I am facing a similar issue. I have 2 arrays to compare but get a [ ] result with intersection(). However, when I compare manually (intersection with pasted outputs) it works!

Was this reply helpful? Yes No
NaufalP 75 on at

Like (0)

Report

Hi @Priddo ,
To be honest I posted this a long time ago and didn't remember what I did (I probably found another way of doing),

But I recreated the flow and it's working as expected now, could've been a bug back then and was fixed by Microsoft.

intersection(variables('var1'),variables('var2'))

Could you share from your side what the issue is?

Thank you,
Regards,

Was this reply helpful? Yes No
Priddo 6 on at

Like (0)

Report

Hi NaufalWahika,

Thanks for coming back to me so quickly!

I found the route of my issue after a lot of trial and error! Intersection() only gave me results if the fields were strings! I had a mixed data type of integers/numbers, boolean and strings. Took me a while to figure out!

Use case:
I am synchronising 2 lists - Microsoft Todo and a SharePoint list. This is to enables me to use custom fields and reports and also benefit from the integration of MS Todo!

To sync from SP to Todo, I have used an event driven flow... all fine. To sync the other way (Todo to SP), I think the only option I have is to schedule a flow that looks for differences between the data sets and updates the records accordingly.

Solution:
I prepare an array for all the open tasks in SP. I then prepare an array containing all the open tasks (or completed in less than a day) in Todo along with the SharePoint ID to the corresponding SP record using xPath. If this information is missing, I add a new list item to SP. For all "exsiting" records, I use an intersection() to find the common records. I then use a Select function on the Todo List with the addition of xPath (counting common records) to identify which records need updating in SP (records with zero count)! This means I do not need an "Apply to each" (until I get to the Sharepoint… yet to work out batch editing / adding of sharepoint records).
There are a few other bits I need to do in the process and happy to share if you (or anyone else) are interested.

Snippets:
xpath(xml(outputs('Compose_JSON')),concat('number(/root/tasks[TodoID="',item()?['id'],'"]/SPID)'))
intersection(body('Select_T2'),body('Select_T1'))
xpath(xml(outputs('Compose_Matching_Tasks')),concat('count(/root/tasks[TodoID="',item()?['TodoID'],'"])'))

Kind regards,
Priddo

Was this reply helpful? Yes No