When I use get a row with forms I keep getting this fail. I copied the name of the location straight from the form question and pasted in the cell and it still says there is no column to match the answer. Any ideas?
How is your flow created? Could you share more details on your flow?
Are you working with Microsoft Forms?
Please share more details to help reproduce this issue on my side.
Thanks for sharing the detailed screenshot of the flow.
I have made a similar test on my side with the following configuration. It works fine.
Do you have a column named as “What is your work..” in the Excel table? It seems that the corresponding column name is School in the Excel table.
Please try to change the column name to the name of the form’s field name then try again with the same flow configuration.
This is my master list of appproval flows. I do not want to change the column name because I will have to change all of my other flows. The column name works fine with all of the other schools. It only failes with Nicholas County Career And Technical Center.
Thanks for updating.
Would you please try to create a new table with the column name changed just for this flow for testing?
I am not sure if it caused by the length of the text. It seems that Nicholas County Career And Technical Center is the longest in the list.
I created a totaly new row in the table with the name NCCTC. The problem is still the same and now I have tried to add a few new ones and they are doing the same thing.
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!