Get sharepoint item ID with parameters

(0) Share

Report

Posted on by polo1604

160

Hello,

I try to get some sharepoint items depending on search parameters and could not find out how to do this.

This is my list (big data) with tracking data of trucks

I filter my list based on type eq '167' (ID= 3857534) and I need the previous item for the same source (in this example 8401, with the ID 3857469).

Thanks for your help !

Polo

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!
@polo1604 Is your type column storing text or a number?

If your type column is a number column your Filter Query should be:
type eq 167

By using single quotes you are indicating that 167 is a string of text.
For more flow troubleshooting tips—check out This YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this tutorial I cover:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @polo1604,
Do you want to get the item based on the same source but a different ID?

Actually, Get items action returns a maximum of 5000 items by default, if you want to get more, you could enable the pagination feature.

In the Filter query, if you want to filter specific items, I think you need to specify the ID one by one, you could configure it as below:

ID eq '3857534' or ID eq '3857469'

Was this reply helpful? Yes No
polo1604 160 on at

Like (0)

Report
Copy link

Link copied!

Hi,
thanks @v-qiaqi-msft and @creativeopinion for your replies, but this was not the issue. Maybe I didn't explain enough what are my needs.

The tracking list contains all data from different trucks, not sorted, with different information. In this case, I extract the items with type eq '167' (all columns are text), which is the type for fueling which shows how many liters of diesel the truck has in its tank. Then I want to get out of the stored data the previous item from the same truck, showing the fuel level, to see how much diesel the fueling was.

The only parameter I have is the truck number ('8401') and I need to find the ID of this previous item to get the fuel level before fueling.

I hope you could under stand a little bit more, as there are thousands of items, I don't know the ID number and therefore cannot filter to it. I need to do a kind of lookup to find the right item. This is my issue.

Thanks again for your ideas 🙂

best regards
Polo

Was this reply helpful? Yes No