Change of query implementation type

Anonymous · ‎11-07-2022

Hi,

Can you please advise if there is an option to change the query implementation type from:

Source = SharePoint.Tables("https://xxx.sharepoint.com/sites/xxx/", [Implementation=null, ApiVersion=15]),

into:

Source = SharePoint.Tables("https://xxx.sharepoint.com/sites/xxx", [Implementation="2.0", ViewMode="All"]),

My source is still the same SharePoint table, but require now a whole range of columns.

Can I edit the existing query, keep all the Applied Steps, but use a new implementation type with ViewMode=All, to retrieve all columns available?

KNP · ‎11-07-2022

Yes, that change should give you what you want.

= SharePoint.Tables("yourURL", [Implementation="2.0", ViewMode="All"])

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.