SQl Get Rows (V2) Unique values

(0) Share

Report

Posted on by NazIM

Im struggling with getting only unique values from the SQL Get Rows(V2) output. Has anyone been able to figure it out?

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

Sort by

365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Perhaps you should use the Get Row Action instead

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NazIM,

I found that you have reply a post to a similar question, does that method not work?

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Array-variables-unique-values/m-p/385325#M32576

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
NazIM 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately not. Get Row does not work with On Premise Data Gateways.

Was this reply helpful? Yes No
NazIM 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Did try it, but it does not seem to work.

Was this reply helpful? Yes No
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nazi,

My example of Flow with Get Row is connected via an On-Premises Data Gatway to an SQL Database. What error do you get when you try it?

Was this reply helpful? Yes No
NazIM 34 on at

Like
a
(1)

Report
Copy link

Link copied!

Just tried again. Get Row (V2) works. I believe the earlier version wasn't.

I guess my issue is different though. What I want is the equivalent of "SELECT DISTINCT <Col> .." in SQL (i.e.: Only unique values / no repeats of the same value).

Was this reply helpful? Yes No
Barret 652 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You might try using the "Execute a SQL Query (V2)" action and pass in an actual SELECT DISTINCT query. That's generally the route I take when I need get distinct data.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @NazIM

In case you do not plan to go an alternate way of performing the sql query, you can use the below method to identify the unique values by creating arrays:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Delete-duplicate-records-items-from-Dynamics-365-CRM-CDS/ba-p/334853

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
NazIM 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255 : That's not supported with On-Premise Data Gateway:

Was this reply helpful? Yes No
Verified answer

NazIM 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255, Didn't try the method shown in the link.

However, what I succeeded with doing is:
1. Get rows (V2) to run the query.
2. put all the field values into an array usig a ForEach action.
3. Used a Union function in a Compose action to union the array with itself
4. Used a join function to create a string from the array.

Very convoluted, but its the only way I got it to work! Phew!!

Was this reply helpful? Yes No