web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to check my value ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 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

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    on at
    Re: How to check my value is available in data row, without using Apply for each?

    Hi @MitheshRpa ,

     

    I made a sample for you.

     

    vxiaochenmsft_2-1715929593720.png

     

    vxiaochenmsft_3-1715929608511.png

     

    Best Regards,

    Wearsky

  • MitheshRpa Profile Picture
    162 on at
    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

    MitheshRpa_0-1715930150814.png

     

  • v-xiaochen-msft Profile Picture
    on at
    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

  • MitheshRpa Profile Picture
    162 on at
    Re: How to check my value is available in data row, without using Apply for each?
    item()?['FileName']
  • v-xiaochen-msft Profile Picture
    on at
    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.

    vxiaochenmsft_0-1715930732412.png

     

     

    Best Regards,

    Wearsky

  • MitheshRpa Profile Picture
    162 on at
    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

  • v-xiaochen-msft Profile Picture
    on at
    Re: How to check my value is available in data row, without using Apply for each?

    Hi @MitheshRpa ,

     

    Select outputs

  • MitheshRpa Profile Picture
    162 on at
    Re: How to check my value is available in data row, without using Apply for each?

    MitheshRpa_0-1715931427270.png

    Not getting in Output

  • v-xiaochen-msft Profile Picture
    on at
    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

  • MitheshRpa Profile Picture
    162 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard