So I built a Flow many years ago to pull info from an Excel file and use that data to populate a SharePoint list. It has been working perfectly. However due to infrastructure changes, I need to recreate it, and the Excel connector is no longer available, so I'm trying to set it up again using Excel Online (Business). Here's basically what I have:
But whenever I put a file into OneDrive, the flow fails at step two saying "No table was found with the name 'NewHire'" when there clearly is one. I've been searching around, but can't find a solution. It worked fine using the old Excel connector and I can't figure out what I could possibly be doing wrong.
Hello,
Are you manually adding the NewHire table name in the Excel Online Connector?
If you open your excel file and press Ctrl+G do you see the table name as NewHire?
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Thanks,
Rahber
I'm converting a CSV to XLSX and putting in the table via PowerShell before it gets uploaded to OneDrive. And yes:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
14 | |
13 | |
12 | |
10 | |
9 |
User | Count |
---|---|
31 | |
21 | |
17 | |
14 | |
12 |