Need Unique array from List Records

(0) Share

Report

Posted on by Achavan

286

From the Invoice entity we need unique array of customers,

we tried using variables and union for the same.

However we are not able to get the array with only Guids.

We tried splits function as well

Requirements : get array of unique customers from List of invoices.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Is 'List of invoices' a sharepoint list? An excel table?

If SP, which column type do you want to consolidate their current values? Is it 'single line of text', choice, lookup...?

In case of excel, here you are an example of how to implement it

https://powerusers.microsoft.com/t5/Building-Flows/Consolidated-email-based-on-date-in-excel/m-p/471936/highlight/false#M57275

Thanx

Was this reply helpful? Yes No
Achavan 286 on at

Like (0)

Report
Copy link

Link copied!

Hi,
we want unique array of Customers from list records (cds connector)

Was this reply helpful? Yes No
Verified answer

Naveen_772 208 on at

Like (0)

Report
Copy link

Link copied!
Hey @Achavan

I tried to solve your problem by implementing the same scenario using the Account and Contact entity.

Account-->Invoice
Contact-->Customer

After you list all the invoice records using the List Record action, Use the "Apply to each" action to loop all the records. Try to get the guid of every customer and add it to the array variable.

After the for-each loop usea compose action to get the unique value by below exp.

Expression:-
union(variables('Array'),variables('Array'))

Screenshot of the flow:-

For getting the Guid I used following Expression:
item()?['_primarycontactid_value']

I hope I am able to help you to solve the issue. Let me know if I can further help you out.

Accept this as a solution if you think the above content fulfills your request.

Thank You
Naveen Gupta

Was this reply helpful? Yes No
Achavan 286 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Naveen_772

can you help me to create two dimentional array of Account and Contact from Opportunity

Was this reply helpful? Yes No
Naveen_772 208 on at

Like (0)

Report
Copy link

Link copied!

Hey @Achavan

I am happy to help.

Thank You

Was this reply helpful? Yes No