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 : nq/Hdpo71BXuiAWvjw4pRD
Power Platform Community / Forums / Power Automate - Using Flows / Ignore case in Get a r...
Power Automate - Using Flows
Answered

Ignore case in Get a row Excel Online(Business)

Like (0) ShareShare
ReportReport
Posted on 11 Aug 2020 10:23:40 by Community Power Pla...

I am trying to get excel row using Get a row Excel Online(Business) connector.

 

It fetches the data correctly, but the data is case sensitive.

 

For eg. If I want to get a row where Key Value is "ABC" then it returns the row.

But, if Key Value is "abc" then it does not return the row.

 

How to ignore the case while matching the condition?

 

Any help?Capture.JPG

I have the same question (0)
  • Community Power Platform Member Profile Picture
    Community Power Pla... on 14 Aug 2020 at 07:01:48
    Re: Ignore case in Get a row Excel Online(Business)

    Hi @v-litu-msft ,

     

    I tried using "List rows present in a table" but I am facing some other issues.

     

    Could you please have a look at https://powerusers.microsoft.com/t5/Using-Flows/List-rows-in-a-table-filter-query-failing/m-p/658218#M17095

     

    Thanks

  • v-litu-msft Profile Picture
    v-litu-msft on 13 Aug 2020 at 08:16:02
    Re: Ignore case in Get a row Excel Online(Business)

    Hi @Anonymous,

     

    Get a row action couldn't do it, because it is case-sensitive, what we can do is to take out all the columns first.

     

    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.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 13 Aug 2020 at 07:59:20
    Re: Ignore case in Get a row Excel Online(Business)

    Hi @v-litu-msft ,

     

    How can we achieve this with "Get a row" action?

     

    I do not want to use "List rows present in a table" due to some other problems.

     

  • Verified answer
    v-litu-msft Profile Picture
    v-litu-msft on 13 Aug 2020 at 07:40:38
    Re: Ignore case in Get a row Excel Online(Business)

    Hi @Anonymous,

     

    You could use the Filter array action to find these rows which ID to upper equals to "ABC", no matter it is Abc or aBc:

    Annotation 2020-08-13 105854.jpg

      

    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.

  • Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on 13 Aug 2020 at 04:07:40
    Re: Ignore case in Get a row Excel Online(Business)

    @Anonymous 

    After using list row present in a table, you can use condition action and choose another pair of Key-Value.

     

    Thanks

    Hardesh

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 12 Aug 2020 at 12:37:31
    Re: Ignore case in Get a row Excel Online(Business)

    "List rows present in a table" returns rows even if case is not matching. That's what I want.

     

    But, I need this to work for "Get a row" action.

     

    Any help here?

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 12 Aug 2020 at 09:21:11
    Re: Ignore case in Get a row Excel Online(Business)

    @Hardesh15 

     

    I can convert the column value to upper/lower case.

     

    But my problem is sometimes the actual excel value can be "aBc" or "abC".

     

    If I convert the column value to upper/lower case it will always be "ABC" or "abc" and it will not match with the excel key column. 

     

    Hence I want to do upper/lower case on excel excel key column

  • Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on 11 Aug 2020 at 15:41:23
    Re: Ignore case in Get a row Excel Online(Business)

    @Anonymous 

     

    You can use condition action. 

    column Value contains toLower(ColumnValue) (i am checking only lower case)

    Based on True and False return, you can use Get a row action in which convert your key value in Upper or Lower case.

     

    Thanks

    Hardesh

     

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 783 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 515 Moderator

#3
trice602 Profile Picture

trice602 299 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans