HI @abm
First sorry, my english not the best.
My lesson the next:
I have an excel table on sharepoint site and i'd like to update another excel file (this file on dropbox equal to my first excel filtered version) with this file's filtered content.
Couple of questions please.
1. automated start when file created or modified in sharepoint folder
Is this excel file?
Yes. this is xlsx file wihout any macros, but for me sceduler as start action is perfect
step 2: list temp table (name: TEST) rows
step 3: apply to each (value from step 2 and delete row)
step 2 and 3 delete temorary table's rows
4. list rows in my to be filtered excel table
Please explain what filter and which excel table is this? Is this excel file from step 1 you mentioned
Yes, this is the file from step 1
5. insert new lines in my test temporary table which has name: TEST
6. read my temporary excel file contents from sharepoint
7. write readed file contents to file on my dropbox
Above yes I understood that you want to insert new lines in your test table. Is this the temporary excel table?
Yes, my temporary table named TEST
Point 6 you mentioned delete rows and now here you saying read temp file? Not very clear here. Is that step 5 test table is the temp file?
yes, i don't find other option i use a temporary file to exchange data between sharepoint and dropbox
Point 7 read file contents and copy to dropbox. Is this the temp file?
yes. a i read temp file and write to dropbox
