How to check my value is available in data row, without using Apply for each?

(0) Share

Report

Posted on by MitheshRpa

162

I had a Datatable in json form, which is having 10 rows, i need to find a value of one paticular column , how can i write this expression in compose?

i need to check my value (rox) is present in below column c1

C1 c2 c3

ram 1 a

rox 2 b

raj 3 c

I have the same question (0)

All responses (12)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

Hi @MitheshRpa ,

I made a sample for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

I tried but , flow has failed!
i am using execute sql query ,
form that i used compose and got my table1

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

Hi @MitheshRpa ,

Please share your expression. It should be item()?['ColumnName']

Best Regards,

Wearsky

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

item()?['FileName']

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

Hi @MitheshRpa ,

It should work. Please share the flow screenshots.

Best Regards,

Wearsky

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

What input i should pass in my filter array ?
Output of select ? or my Query Output

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

Hi @MitheshRpa ,

Select outputs

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

Not getting in Output

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (1)

Report

Re: How to check my value is available in data row, without using Apply for each?

Hi @MitheshRpa .

Please check the difference between your flow and my sample flow. To be honest, I don't know how your flow is designed. I can only build a solution based on the sample data you provided.

Best Regards,

Wearsky

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

Re: How to check my value is available in data row, without using Apply for each?

I followed ur steps.

My select output was below
[
  {
    "Mail test.pdf": ""
  },
  {
    "SelectionBot.docx": ""
  },
  {
    "RA@%U8998.pdf": ""
  },
  {
    "DataBase.txt": ""
  },
  {
    "Medical insurence questionnare -pojištění pro cizince.docx": ""
  },
  {
    "I-94-1.pdf": ""
  },
  {
    "Medical insurence questionnare -pojištění pro cizince (1).docx": ""
  },
  {
    "Medical insurence questionnare -pojištění pro cizince (1).docx": ""
  },
  {
    "Visa.pdf": ""
  },
  {
    "new_passport.pdf": ""
  },
  {
    "Medical insurence questionnare -pojištění pro cizince (1).docx": ""
  },
  {
    "I-94.pdf": ""
  },
  {
    "I94 - Official Website-2.pdf": ""
  },
  {
    "STEM_OPT_EAD.pdf": ""
  },
  {
    "Medical insurence questionnare -pojištění pro cizince (1).docx": ""
  },
  {
    "STEM OPT EAD CARD.pdf": ""
  },
  {
    "Batch Lists - May 2024.pdf": ""
  },
  {
    "Medical insurence questionnare -pojištění pro cizince (2).docx": ""
  }
]

now i need to filter

Was this reply helpful? Yes No