Answered

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

(0) Share

Report

Posted on by CDOG123

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 Flow

Error Message

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

CheckMate 75 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

CDOG123 9 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No