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.
Highlighted
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.
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

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,704)