My flow works!...then it doesn't?

[jguzmanlozada]

Greetings!

I created a flow that needs to do the following, after a response is submitted:

1. Get response details, where it gathers the form's response to it's only question: Enter Full Email
2. Then the Flow has get my profile, where it looks for Mail
3. Then the flow  gets a row , which point s to an excel file:
   • Where there is a table that contains  emails in the Key Column 
   • And then the Get Row is configured to search for on key value,   a dynamic value from the step 1: Enter Full Email
4.  Then Sends an email with the row value...  I tested it and It works!!!  I received an email with the data inside the row.

But then, if another user but me tests it, it does fails saying "No row was found with id (the user email.com)", but I do see it there in the table, in fact is the same table that did work with my test before (my email is in the table)

Also, if I change the Key Value, to have dynamic content of Responder's Email it does fails, even with my account.  I would think this is the ideal setting:

Again, the excel file contains email address on the Key Colum User and it does finds mine when I do tess.  I know I'm close to have it done, …and I'm happy for my improvement, as this is my first flow ever.  Therefore any light shed will be appreciated!

JM

[abm]

Hi @jguzmanlozada 

Did you checked the run history? What its returning in each steps?

[jguzmanlozada]

Thanks @abm !

The run history hows all previous steps ok, but the get row, where it fails with No row was found with Id, then the form respondent email is shown.   That email is in fact taken from the previous flow steps and it does exist in the excel file the Get Row is pointing.

Makes sense?

[abm · Accepted solution]

Hi @jguzmanlozada 

Make sure that email is all case sensitive and no spaces between. Try to trim() before you compare.

[jguzmanlozada]

Thanks @abm !

I was thinking about that after I finish some testing last night.  I did change all the emails to lower caps, then tested again and it works!!  So yes, the caps does affect the Get Row results.  I don't mind leaving it like that, but is there a way to go around that?  It may help others that's why I am asking, because as far as I am concern, this case is closed.

Thanjs!

JM