Unanswered

Using List ID in Filter query

(1) Share

Report

Posted on by tverticchio

I hvae two SP List (a detail and summary list). Both lists are population at the same time via a flow taking information from a form. Once it is determined that two items on the detail list can be summarized, the user will add a identifier to the detail list. I want to be able to update the summary list with this user defined identifier. My idea was use use the List ID as a way to 'find' the summary item. If the flow that creates the items, I create the Summary list item first and then created a numeric column on the Detail list to store the Summary List ID. When the user adds the identifier to the detail list a flow runs looking for the change. I am using the filter query in Get Items for the Summary List - ID eq Summary List ID. Below:

Unfortunately nothing is ever found in this Get Items action. I suspect it is due to a difference in data type. I have tried lots of different things and nothing seems to work. What am I missing?

Thank you

Categories:

Building flows

All responses (7)

Answers (0)

Sort by

trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tverticchio ,

Can you put the dynamic content between apostrophes, such as ID eq 'dynamiccontent'.
tverticchio 64 on at

Like
a
(1)

Report
Copy link

Link copied!

Just tried that. Same result.
trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tverticchio ,

Can you share more of your flow please? I'm traveling tonight but would love to review this over coffee in the morning, it sounds like a solvable task.

Also, share the rows from each list you want to compare and update.
tverticchio 64 on at

Like
a
(1)

Report
Copy link

Link copied!

I assume you have already had your morning coffee - afternoon tea perhaps??

Attached are screen shots of the flow. It is the Get items 2 under Apply to each 2 that is not finding anything. 'Community List ID' is a numeric column on the Detail list, populated by the ID of the Summary List when created. Both lists are initially populated in the same flow when a form is submitted. Hopefully this provides enough detail for you. Thank you - appreciate it!

Flow screen shot....
trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tverticchio ,

I'm out of time this morning but checking some posts from the phone.

Number to number doesn't use apostrophes. I'm wondering if you have checked the output from get items, is there anything there? I'm trying to determine if it is the get items action or the condition that is the root cause.

What I would also try is used a different unique column or two and see if that works.

Also make sure both I'd columns are in fact number columns; is very easy to assume they are but maybe one is actually a string. So validate by using string() for both values and user the apostrophes for the string value.

Tom
tverticchio 64 on at

Like
a
(0)

Report
Copy link

Link copied!

1. Removed the apostrophes. Still doesn't work
2. Do you mean Get items or Get items 2? If a record is found under Get Items, there is a different set of actions. The Get Items 2 comes into play when nothing is found under Get Items. Right now when I run, I am assuming that nothing is found because when I look at the output of the run, this section is greyed out. (see below) Perhaps I made a bad assumption here.
3. I just ran with a hardcoded value in the filter query for Get Items 2 and the result is also greyed out.

So, now I am reevaluating what I thought the issue was to begin with. Basically, I am doing a Get items with a filter query on X. If not found, I want to do another Get Items using a different filter query...

Thank you!
tverticchio 64 on at

Like
a
(1)

Report
Copy link

Link copied!

Ultimately, I reworked the flow and did not do a second Get Items if nothing is found in the first. The reworked flow seems to be providing the correct results.