Sharepoint Input List dropdown / selection

I'm trying to connect to a Sharepoint via the Sharepoint Input List Tool and run this on the Gallery. Currently, the Sharepoint Input List Tool has an inbuilt option to select the required list from the Sharepoint. Is there a way that this list can be populated as a dropdown list when this is run on the Gallery or Analytic App ?

The reason I require this is so that it gives the user an option to choose the required data from the list and run the workflow.

Could someone please help at the earliest ?

2021-03-26_15-28-25.png

Sharepoint

Accepted answers

danilang

Hi @Mario36

The only way that I can think to do this is to call the SP API and get a list of the SP Lists defined on a specific site. Use this to populate the yxdb.

The internals of the SP Input tool are a black box, but it probably does something similar in the background to populate the list.

Dan

All comments

jacob_kahn

I'm wondering if you can use a Dropdown Interface tool that updates the List value.

The Dropdown interface tool allows you to specify certain values to push to the tool being updated via the connected Action tool with a specified value.

Have you any experience in that world?

Jacob

danilang

Hi @Mario36

If the names of the SharePoint lists don't change regularly, you can just enter the list as manual entries in a Drop Down tool. Connect this to the SharePoint List Input tool and have the action tool update the List entry. It will help if you always use the same view, i.e. Default for each list

Dan

Mario36

I did explore this route but it did not help. The dropdown needs to be dependent on a list and I want this list to be on the dropdown. Confusing but hope that made sense.

Mario36

Hi Dan,

The Sharepoint list does change monthly, I did try this option of choosing a Date tool to provide the user to choose the month and then convert this date to match the sharepoint list name and feed this as an input on the Dropdown List. Unfortunately, this did not help either.

Reference Date = 3/26/2021
Converts to = March2021
Concatenates with the Sharepoint List Name = ListMarch2021
Do the same for the prior month
Feed this as a dropdown list

This did not work.

image.png

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703