Appending record using Share Point

[Edy_Tan]

I am exploring the QAA task chain by @Emile_Koslowski but my customer can only use share point (instead of google sheet).  I made changes to the code however I face the following challenges

1. there is no option to append a record to a file in share point, I have to open a new file, read and write from existing file to the new file, add in a new record, and then rename the new file to the existing file; is there a better way for share point?

2. new record is appended into a file (based on item 1) and then I read it back again, the new record is not found, only the existing record before the append.  When I rerun the QAA, then the appended record will appear

The following are the screen shot of the QAA

a. Append a record to a file and read back the file

Append and read back

b. QAA function to open an existing file, write to a new file, append a record and save back to the existing file

Append function part 1

Append function part 2

Appreciate any suggestion or comments on this

[AfeefaTk]

Hi @Edy_Tan 

1. there is no option to append a record to a file in share point, I have to open a new file, read and write from existing file to the new file, add in a new record, and then rename the new file to the existing file; is there a better way for share point?

Ans : Can you use Microsoft Excel connector to get this done? Try using the "Add Row To Table" or "Add Rows To Table (Batch)" block.

https://community.qlik.com/t5/Official-Support-Articles/How-to-Getting-started-with-Microsoft-Excel-...

Thanks

[Edy_Tan]

ok thanks