cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chanshaw
Level: Powered On

Matching column and form question fails in flow

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?Get a row fail.PNGGet a row fail2.PNG

6 REPLIES 6
Community Support Team
Community Support Team

Re: Matching column and form question fails in flow

Hi @chanshaw,

 

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.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
chanshaw
Level: Powered On

Re: Matching column and form question fails in flow

This is my flow. And yes it is microsoft forms.Get a row fail 3.PNGThis is where my excel file isGet a row fail2.PNGScreen shot of the excel column that the response matchesget a row fail 4.PNGThis is the response that didn't find the column

Community Support Team
Community Support Team

Re: Matching column and form question fails in flow

Hi @chanshaw,

 

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.

1.PNG2.PNG

 

Please try to change the column name to the name of the form’s field name then try again with the same flow configuration.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
chanshaw
Level: Powered On

Re: Matching column and form question fails in flow

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.

Community Support Team
Community Support Team

Re: Matching column and form question fails in flow

Hi @chanshaw,

 

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.

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
chanshaw
Level: Powered On

Re: Matching column and form question fails in flow

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.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,786)