Doing a lookup for an SQL Get Row action

Like (0) Share

Report

Posted on 29 Jun 2018 19:57:46 by martinav

3,340

I have two values that need to match and to return the value of another column based on that search. A typical lookup with and. Is there a way to do this? This was the statement for the and condition I was wanting to use, but I not know how to tell it to return the rowID for the true condition.

and(equals(body('Get_row_-_Documents')?['DocumentID'],triggerBody()?['DocumentID']),equals(body('Get_row_-_Documents')?['LatestRevisionNo'],triggerBody()?['RevNr']))

I have the same question (0)

All responses (2)

Answers (1)

v-yamao-msft on 03 Jul 2018 at 05:38:26

Like (0)

Report

Re: Doing a lookup for an SQL Get Row action

Hi @martinav,

Could you provide more info about your flow? How is it configured? Are you using the function in a Condition? Have you created a column of Id and set it as primary key?

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Verified answer

martinav 3,340 on 03 Jul 2018 at 13:49:30

Like (1)

Report

Re: Doing a lookup for an SQL Get Row action

I have learned much since my post. Haivng to learn an entirely different language (Odata) to do a filter is yet another oddity that takes hours to figure out. Powerapps, Flow, etc are great tools, but there are quite a few things like this that really keep me from being as productive as I should with these tools. Here is how Ive ended up doing lookups.

I have to do an SQL Server - Get Rows action. Its the only action that allows the filter. Then, doing a simple simple equality with an 'and'.

This works, then I nested several of these one after another to gather data from other tables. This creates an apply to each, even though the results of my filters are only one item. It makes it cumbersome to work with, but it does work.

Was this reply helpful? Yes No