Unanswered

Union function not working as expected

(0) Share

Report

Posted on by Bee1

Hello,

I am trying to extract unique dates from a filter array of dates using compose action with union function but encountered the following error:

I checked the expression but unable to spot any problem with it. Much appreciate any help to troubleshoot this issue. The union expression I used is

union(outputs('Compose_2__-__Get_Booking_Dates_'),outputs('Compose_2__-__Get_Booking_Dates_'))

Thanks in advance for your help.

@ekarim2020

@reza dorrani

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Union() is designed to work on arrays and you are feeding it a string date. What does your Compose 2 formula look like? It should be an array of dates, but it's evidently returning a string.

Was this reply helpful? Yes No
Bee1 21 on at

Like (0)

Report
Copy link

Link copied!

Hi, Pstork1

Thanks for the quick response. Compose2 formula is as follows:

body('Filter_array_EXCEPT')[0]['BookingDate']

Filter array Except is filtering a SharePoint lists of booking dates that is not in another list.

The output of Compose 2 is as shown below:
I need to get the unique booking dates. I need to get unique dates to create item in another list. Therefore I used the union function. But actually it looks like the Compose2 is showing 1 date although the Filter array Except identify 17 exceptions of the same booking dates. Therefore second Compose with union function is not needed? Appreciate if you can advise.

Was this reply helpful? Yes No
Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The problem is that your Compose is selecting just the first record of the array, you have specified the index [0]. So you are passing a string value to the Union(), not an array. I think what you want to use for the Union is the output of the filter array, not the compose.

Was this reply helpful? Yes No