web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : WY86/BHZBa/vAC4ALd2qUJ
Power Platform Community / Forums / Power Automate - Building Flows / How to prevent the App...
Power Automate - Building Flows
Answered

How to prevent the Apply to each when searching in my sharepoint list ?

Like (0) ShareShare
ReportReport
Posted on 13 Dec 2022 23:46:13 by CU16021406-1 1,037

Dear Experts, 

In my flow i use the "Get Items" connector to search in a particular column using the Filter Query.

After using the Get Items connector i have all the columns of my sharepoint list available in the Dynamic content.

 

For example using the Select variable i get alle the names of the display_name column 

PeKi72_0-1670974913312.png

 

But if i want to use this string below in the compose variable it puts the compose automatically in the Apply to each.

Is it possible to use the string without the Apply to each? Or can this be done better. 

 

PeKi72_1-1670975125640.png

Gr. P

 

 

I have the same question (0)
  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on 14 Dec 2022 at 03:37:26
    Re: How to prevent the Apply to each when searching in my sharepoint list ?

    Hi @PeKi72 

     

    You can use the join function on the result of Select to convert the returned array into a string:

    vliweimsft_0-1670988994948.png

    join(body('Select'),',')

    vliweimsft_1-1670989021181.png

    Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

     

    Best Regards,

    Levi

     

     

  • CU16021406-1 Profile Picture
    CU16021406-1 1,037 on 14 Dec 2022 at 02:31:58
    Re: How to prevent the Apply to each when searching in my sharepoint list ?

    Hi thank you for your response.

    I do not want to get a certain field value. I just want alle the information that i have set in the Filter Query of the Get Items connector. When i put a sharepoint column out of Dynamic content into a Select variable. I get all the data from that column. That is good. That is what i want. Is it also possible to use the url in my example without using the apply to each. 

  • v-liwei-msft Profile Picture
    v-liwei-msft on 14 Dec 2022 at 01:48:43
    Re: How to prevent the Apply to each when searching in my sharepoint list ?

    Hi @PeKi72 

     

    The return value of Get items is an array, so when you want to get a certain field value of each row, you must pass Apply to each.
    Apply to each does not appear when using Select because this operation is performed internally by Select.

    Could you please tell me why you want to avoid Apply to each, and what kind of requirements do you want to achieve?

     

    Best Regards,

    Levi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans