
Hi all,
I am trying to create a flow starts with "when a file is created" trigger of sharepoint. And after that I would like to use "List rows present in a table" action to get rows from created file. However, I receive "BadReques" error.
I remember using dynamic name for this action was working previously by using "Identifier" of created sharepoint file.
Does anyone else have an idea on how to fix this problem?
I understood the problem. It is not related to "list rows present in a table" action, it is related to how I created the original file in previous steps. When a new mail arrives I am saving attachments to a Sharepoint folder, but I was trying to eliminate image attachments (company logo etc.) and only save excel attachments.
In order to that I created below flow. First I applied a filter array to get only excel attachments as below.
Attachment is inline is not equal to false
And then created file based on Outputs of Filter array. But it seems this does not work. Even the file in the folder is shown a normal excel file, when I tried to open it I get "Excel can not open the file because file format or file extension is not valid" error. I think I need to fix this.