web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Online Business ...
Power Automate
Suggested Answer

Excel Online Business “Create Table” Returns itemNotFound for All Users Except Me

(3) ShareShare
ReportReport
Posted on by 21

I have a Power Automate flow inside a Solution that creates an Excel file in OneDrive and then uses Excel Online (Business) → Create Table to build a table inside that file.

The flow works perfectly for me, every time.
However, the flow fails for every other user, even when:
  • They are added as Run‑Only Users
  • They use their own OneDrive connection
  • They use their own Excel Online Business connection
  • The file is successfully created in their OneDrive
  • The dynamic File → Id from the Create File step is passed into Create Table
  • The Create Table action has been deleted and rebuilt
  • All connection references are inside the Solution
  • The flow is running entirely under their identity
The failure is always the same:
Flow run failed. Action 'Create_table' failed: Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'

Important details:

  • The file is created in the user’s OneDrive.
  • The file is empty because Create Table never runs.
  • The Create Table step fails even though the File ID is correct.
  • The flow only works for me, the creator.
  • The flow fails for every other user, regardless of permissions or connection bindings.
  • Rebuilding the action does not fix it.
  • Using dynamic File ID does not fix it.
  • Using their own connections does not fix it.
At this point, it appears that Excel Online Business is unable to access the user’s OneDrive “Excel drive,” even though the OneDrive connector can.
This behavior makes no sense from a user perspective, and I need guidance on:
  1. Why Excel Online Business cannot find a file that OneDrive just created
  2. Why this only affects other users and not the flow creator
  3. Whether this is a known issue with personal SharePoint site provisioning
  4. How to make the flow work for any user, not just the creator
Any help or official guidance would be appreciated — this is blocking deployment.
Screenshot 2026-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    2,430 on at
    Use:
    • Excel template with prebuilt table
    instead of dynamically creating tables.
  • Suggested answer
    Valantis Profile Picture
    5,479 on at
     
    This is a well-documented issue with two separate root causes.
     
    Root cause 1: File ID format mismatch between connectors
     
    Microsoft docs confirm: the OneDrive for Business connector and the Excel Online Business connector use different internal file identifiers.
     
    The OneDrive connector returns an Id property, but the Excel Online Business connector expects a File Identifier property. These are not always interchangeable and the difference only surfaces for other users because your OneDrive is already fully provisioned while new users' personal SharePoint sites may not be.
    In your Create Table action, instead of using the Id output from Create File, use the Path output (the full file path) or the File Identifier output specifically.
    The path-based reference is more reliable across users than the GUID-based Id.
     
    Root cause 2: Personal SharePoint site not yet provisioned
    When a user's OneDrive/personal SharePoint site hasn't been fully provisioned, the Excel Online Business connector (which routes through Microsoft Graph and SharePoint) can't find the file even though the OneDrive connector can create it. The OneDrive connector uses a different API path that works before full provisioning. Adding a Delay of 10-15 seconds between the Create File and Create Table actions can resolve this for affected users.
     
    The confirmed fix combination:
    1. Change the File input in Create Table from the Id output to use the full path expression:
    @{outputs('Create_file')?['body/Path']}
    2. Add a 15-second Delay between Create File and Create Table
    3. If still failing for specific users, they need to open OneDrive once in their browser first to trigger site provisioning
     
     

     

    Best regards,

    Valantis

     

    ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

    ❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

    🏷️ For follow-ups  @Valantis.

    📝 https://valantisond365.com/

    💼 LinkedIn

    ▶️ YouTube

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 632

#2
Haque Profile Picture

Haque 458

#3
Valantis Profile Picture

Valantis 357

Last 30 days Overall leaderboard