Use of "SEARCH ROWS"

(0) Share

Report

Posted on by DiePic

448

Hi all

I need to retrive a specific row from a table to continue my flow.

In my table "cr07a_athdocopp" connected with table "opportunity" (column "cr07a_titoloopportunita"), as in picture, I need to find if exist a row with column "cr07a_categoriaopportunitaname = Conferma Ordine Cliente" .

I try in this way

but result is always an error.

Somebody can help me to understand where I'm mistaken?

thanks in advance.

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (1)

Report

Hi DIE PIC,

The easiest way to add a filter in a search row is Fetch XML inlist rows

Was this reply helpful? Yes No
DiePic 448 on at

Like (0)

Report

Hi Abdul Wahab

thanks for your reply.

I try as you suggest, in this way

but return me this error

I need to retrive "YES" if there is a row with
"cr07a_categoriaopportunitaname" eq "Conferma Ordine Cliente"

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi DIE PIC

You are missing round brackets. I guess

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (1)

Report

Hi DIE PIC,

Did you download a query from the model-driven app? or Fetch XML Builder

or Is it created by you?

Was this reply helpful? Yes No
DiePic 448 on at

Like (0)

Report

Hi Abdul Wahab

But I must work with "Fetch XML" or on "List Rows"?

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

Use List Rows action

saralagerquist.com/.../

Was this reply helpful? Yes No
DiePic 448 on at

Like (0)

Report

Hi Bipin Kumar

With "List Rows" and "Filter Rows", I've obtained a result, but now I've 2 problems:

1 - I need to search column "_cr07a_categoriaopportunita_value" not by ID but by name ("Conferma Ordine Cliente") ... there is a way?

2 - with "Search Rows" I've a result of rows find, with "List Rows" no ... how can I recognize when if the flow find a row or not? There is a way to count the row finded from the flow?
Can make me an example pls?

Was this reply helpful? Yes No
DiePic 448 on at

Like (0)

Report

Hi Abdul Wahab

I'm not much time that I work with Dynamics, and there are a lot of thinghs that I dont know.

How can I find and use "Fetch XML Builder"?

In this case I've written the query and the problem is that I put the value and not the ID of the value.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="cr07a_athdocopp">
   <attribute name="cr07a_titoloopportunita"/>
   <attribute name="cr07a_categoriaopportunita"/>
   <attribute name="cr07a_categoriaopportunitaname"/>
      <filter type="and" >
      <condition attribute="cr07a_titoloopportunita" operator="eq" value="@{variables('strIdOpportunity')}"/>
      <condition attribute:"cr07a_categoriaopportunitaname" operator="eq" value="Conferma Ordine Cliente"/>
      </filter>
</entity>
</fetch>

if I change the value with ID_value (50c56d74-f634-ed11-9db1-0022489dd6df), the flow work. But I will find the row with value and not with ID_value if it's possibile.

Another problem is how can I count how many row find the flow? with "Search Rows" at the end I've a number, how can I obtain this number in this way?

Was this reply helpful? Yes No
Verified answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi DIE PIC,

Download the XRM Toolbox and use fetch XML Builder... or Make use Fetch XMLs as defined in my lat rply

In the control condition. Use "length(outputs('nameOfListRowsComponents')?['body/value'])" with greater than 0

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi DIE PIC

You need to download Fetch XML with similar properties

Was this reply helpful? Yes No