topic Re: Appending record using Share Point in Qlik Automate

Appending record using Share Point

Edy_Tan — Wed, 19 Apr 2023 02:07:53 GMT

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

Re: Appending record using Share Point

AfeefaTk — Mon, 24 Apr 2023 03:25:22 GMT

Hi @Edy_Tan

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-in-Qlik-Application/ta-p/1838336

Thanks

Re: Appending record using Share Point

Edy_Tan — Sat, 22 Apr 2023 06:30:09 GMT

ok thanks