Finding and updating a single item in a Sharepoint List

(0) Share

Report

Posted on by wiredupjax

195

Dear Community,

I am writing a flow to count the total number of items in a SharePoint list. For example, the total number of entries for a particular location. After the total, I want to update a second SharePoint list item with the total for each location.

I can easily count and total in 2 separate variables. My challenge is finding the record in the 2nd SP list and updating it with the specific value.

I've looked at: https://powerusers.microsoft.com/t5/Building-Flows/How-to-update-an-item-in-a-SharePoint-list-base-on-the-changes/td-p/100880 to no avail.

How do I find a specific record in a SharePoint list and update it?

Get items (from location list)
Filter array (from location list)?
Update item (from location list) but how do I get the "ID" of the location?

Thanks, Jason

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (1)

rsaikrishna 3,703 on at

Like (0)

Report

@wiredupjax ,
Get Items action has following parameters:
a. Filter Query: You can insert any filtering requirements here.
b. Order By: You can sort the filtered items as well.

Can you try above without using Filter Array?

Let me know how it works for you.

Was this reply helpful? Yes No
wiredupjax 195 on at

Like (0)

Report

The filter for the 1 item worked.. it selected the 1 record and i was able to count and save.

Next question--how do i update the 2nd location? Do I do another get items with the filter?

Was this reply helpful? Yes No
rsaikrishna 3,703 on at

Like (0)

Report

@wiredupjax

Can you explain about 2nd location means?

Do you mean another list? If so, you use Get Items with filter condition. After that, you try Update Item action to update it.

Regards
Krishna

------------------------------------------------------
If my replies helped you, please mark it as Accepted Solution with ThumbsUp.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @wiredupjax ,

I have made a test on my side to create a List 1 and List 2 as below:

The location column in the two lists with single line of text type, the count field in the List 2 with number type.

And multiple items in the List 1 would has only one corresponding item in the List2.

And then you could refer to screenshot below to create the flow:

The length expression in the count field as below:

length(body('Get_items_2')?['value'])

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
wiredupjax 195 on at

Like (0)

Report

Perfect! This is much more elegant than my approach with counters/incrementors.
Thank you @v-alzhan-msft

Was this reply helpful? Yes No