cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Error while getting data from excel using flow

Hi Team,

 

I have created power automate flow, that reads data from excel file stored in SharePoint list using key Column (table column name ) and key value (id).

But the excel file not fetching the key value , so the flow throws and error. I'm not getting what to use on the place of key value.

 

Error:  Action 'Get_tables' failed

 

Can someone help me to fix the issue.

Attaching screenshot for reference.

 

error1.4.jpgerror1.3.jpg

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
sayyedkohler
Advocate II
Advocate II

I don't know what you are trying to do with that if you specify then it will easy for us to answer your query.
But I am answering based on screenshot.
Actually You are using connector which will get a particular row for you.
So you need to pass CustomerName in Key Value field.
Let me give you an example: its like you are trying to get a row where CustomerName is 'Specific Customer Name'.
If you want to get all rows of Excel then you need to use List Rows present in a Table connector.

View solution in original post

2 REPLIES 2
sayyedkohler
Advocate II
Advocate II

I don't know what you are trying to do with that if you specify then it will easy for us to answer your query.
But I am answering based on screenshot.
Actually You are using connector which will get a particular row for you.
So you need to pass CustomerName in Key Value field.
Let me give you an example: its like you are trying to get a row where CustomerName is 'Specific Customer Name'.
If you want to get all rows of Excel then you need to use List Rows present in a Table connector.

Anonymous
Not applicable

Yes it's working.

I have tried List Rows present.

 

Thankyou so much.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,590)