Sharepoint Version History Scraping in Dataflow

[Anonymous]

Hello,

I'm in the middle of creating a dataflow that has a function that scrapes the sharepoint list of their version history but I am getting this prompt over and over per each item that I have in sharepoint list:

Is there a way to prevent this prompts from reoccuring?

I also used this function in desktop app but didn't get the same prompts as when I do it in Dataflow.

I'm invoking the function in this page for reference

[ibarrau]

Hi. I would suggest modifying the code you have on that post. It looks like it's generating a different url for each item. You can try Web.Contents good practices in order to use one url as a source for all items. You might get to that if you add the following items as RelativePath parameter:

- VersionsRelevantSharePointListName => Your SharePoint List Name

- VersionsRelevantItemID => SharePoint list item ID

You can check how to modify power query code for web contents on the following posts:

- https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request

- https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

I hope that helps,