Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Getting List name and View from Control Parameter

pvijendr
7 - Meteor

Hi All,

 

I am using Sharepoint list connector to connect to SP list and selecting the list from List dropdown and view from view dropdown.  Is there any way to get the List name and view name using control parameter and get the results ?

1 REPLY 1
MattD
Alteryx Alumni (Retired)

Hi Padmanabhan!

 

That’s definitely possible! The approach would include configuring the SharePoint List Tool with your desired URL, username, and password, and putting a sample (place-holding) list/view in the tool. Then collapse this tool into a batch macro and map a control parameter to the SharePoint List Tool with an Action Tool set to “Update Value” on the specific string used as a placeholder. If you map a list of the fields you’d like to update with to the control parameter of the batch macro, it will update accordingly.

 

I’ve gone ahead and attached a sample of the approach to this post, and included a link to a video detailing the construction of batch macros below:

 

https://www.youtube.com/watch?v=YIAbQGQ_Hkg

 

If you run into any issues at all in implementing the approach above, please just let us know at support@Alteryx.com!

 

Best,

Matt D

Former Alteryx, Inc. Support Engineer, Community Data Architect, Data Scientist then Data Engineer
A batch macro is a special kind of macro that is typically needed to process a group of records based on a control parameter. The control parameter determines which group of records will be processed through the underlying macro logic. The macro will be run from beginning to end for each control ...
Labels