List Rows present in a table - Bad Gateway error 502

[KhalilAr42]

Hello everyone,

I'm trying to create a flow that triggers once an excel file is added to a SharePoint library to take the rows present in that excel file and move them to a SharePoint list.

I have a problem with the Excel action - list rows present in a table, It seems that the action will retry forever until it fails with an error BadGateway 502 : 

I found in the internet that the problem is that the excel file does not give the permission to be editable/readable. 

How can I force my SharePoint library to give edit permission to all excel files uploaded to it? 

Or what is the solution to this error? 

[v-jefferni · Accepted solution]

Hi @KhalilAr42 ,

You can edit library permissions from in library settings:

But pay attention to the notes, you need to share the specific items again with edit permission if you have shared with read-only permission before.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[KhalilAr42]

Hi @v-jefferni 

Thank you for your answer it did fix my problem

Kind Regards