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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / For a selected file co...
Power Automate
Answered

For a selected file connector and excel online (buisness) connectors

(0) ShareShare
ReportReport
Posted on by CDOG123 9

Hi, 

I am trying to insert rows into tables/access rows of tables that are in a file in my sharepoint library using the 'For a selected file' sharepoint trigger. However, I cannot get this to work. Every time it says that the table does not exist. Can someone point me in the right direction?

 

Simplified FlowSimplified Flow

Error MessageError Message

Categories:
General topics
I have the same question (0)
  • CheckMate Profile Picture
    CheckMate 75 on at

    CheckMate_1-1627270435913.png

    hi @CDOG123 

    i think that the table option will not appear unless you have format the excel file by table, to include the headers

     

     

     

  • Verified answer
    CDOG123 Profile Picture
    CDOG123 9 on at

    Thanks @CheckMate but I think I did not explain myself very well in the first instance - I meant that if I use the file ID to lookup the file, I run into issues, despite the fact that this works for me in other flows. 

     

    However, I worked out what I was doing wrong - I should have been using the output 'Identifier' rather than 'ID' or 'ItemID' - I hadn't realised that they were all different things.

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

News and Announcements

Welcome to the Power Platform Communities

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 February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans