I created a flow that needs to do the following, after a response is submitted:
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!
Solved! Go to Solution.
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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!