Hi,
I am trying to get data from a Microsoft Excel Table to use in my Power Automate flow using the "Get a row" function. When I try to locate the Excel file and table, the File field is blank and shows no results after I fill in the Location and Document Library fields.
I know that the document exists in that location because I am using that same document in the same flow with the "Run a Script" function and it works fine. I also made sure to format my data in the Excel file as a table and used the 'Insert Table' command to generate the table.
I am relatively new to PA so please let me know if I am missing something. Thanks.