web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows What to do with GetIte...

Power Automate - Building Flows

Answered

What to do with GetItems (Sharepoint)

(0) Share

Report

Report

Posted on by AlexS2023

9

(Sorry for the silly question but I'm new to this and struggling to find an answer.)

I am trying to find the ID of a record matching specific criteria. I have used GetItems, with a filter, which should be finding the right record. But how do I actually process the information from there?

I want to find the ID of the (top) record, and set it to a variable for later use. I just don't know how to do it ... I know it must seem elementary...

TIA

Alex

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Ryan_B 446 on at

Like (0)

Report

Re: What to do with GetItems (Sharepoint)

When you say you're using Get items with a filter, are you referring to the Filter query section of the action? If so, what is your filter and how are you trying to find a specific record? What are your qualifiers?

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (2)

Report
Re: What to do with GetItems (Sharepoint)

Hi @AlexS2023

You can write an expression to get the Id of the first record obtained from "Get items" action. The Id can be collected in compose action or variable. In the below example, I have used compose action and check if there is any records returned by "Get items" action. If there is no records then in compose, we will put zero else we store the Id of the top or first record:

Expressions need to be entered in the expression box as highlighted in the above screenshot. Expression used for getting the Id of first or top record is:

if(greater(length(outputs('Get_items')?['body/value']),0),first(outputs('Get_items')?['body/value'])?['Id'],0)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans