Answered

Use Variable for a List Name with Get Items, Create Item, Update Item ??

(0) Share

Report

Posted on by kreeder

I have a flow based on file creation and modification that creates/updates items in lists based on metadata from the file. There are 25 possible list destinations based on a metadata column. I use the Switch Case to direct the flow to the corresponding list. In each Case there is logic that I have to recreate 24 times to use the correct list in get,update,create. I would like to be able to set a variable in the each Case and write the logic one time using the variable list name in subsequent get,update,create. Is this possible?

Get Items doesnt seem to mind that a string variable

But Create Item complains

Is there a better way?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (2)

Report
Copy link

Link copied!

Hi @kreeder,

I am afraid that filling in the variable in the List name is not feasible for Create item and Update item.
Because these two actions need to determine the list name to get the fields that need to be created or updated.
Maybe you could try using Send an Http request to SharePoint to create Item and Update item.
I did a test on my side, using Create item as an example:
Updating an Item is similar to creating an Item. Here are some links you can refer to on how to update items using Http request.
https://veenstra.me.uk/2018/07/02/microsoft-flow-update-a-list-item-with-a-people-field-using-rest-api-in-the-send-an-http-request-to-sharepoint-action/
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest
Please take a try.

Best Regards,
Barry

Was this reply helpful? Yes No
kreeder 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks I will give it a try.

Was this reply helpful? Yes No