Unanswered

Ignoring Case / Case Sensitive

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good Morning,

I am building my first ChatBot. It connects to a, Excel Spreadsheet (Table) and uses the Get a Row action.

I have made the connection work and I am getting data back and forth. The issue is, I would like the input of the flow to either:

Be case insensitive (Most desired)
Change everything in the input to Upper Case

I'd rather not have the user to have to worry about using upper or lower case. Can I have the Action receive the input and search for the desired row regardless of upper or lower case?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

It might be useful to know that there are functions in Power Automate which can be used to convert strings to upper or lower case:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#toLower

Hope this helps a bit?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
What we ended up doing was this:

In our Flow, we initiated a variable to hold the user's input
We then used the 'Compose' feature to run the variable through the toUpper function
We sent that result into the Excel 'Get a Row' action
Since all of the Acronyms in our list are upper case, this works out fine for us.

We have yet to find a way to just ignore case, so this question still stands.

Was this reply helpful? Yes No