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

Community site session details

Session Id : JiOEQD+0kBdW9IzbN8/xT1
Power Automate - Building Flows
Unanswered

Array only pulling one entry

Like (0) ShareShare
ReportReport
Posted on 1 May 2025 09:22:13 by 56
Hi all
 
I'm working on a flow to notify us of things expiring within 60, 30 an 1 day - I've set some dummy data for the 60 day notification, as I'm working on that bit first; thanks to someone on here, I got the filter query working, but now have run into the issue where the array is only pulling the first record (name begins with an A, my dummy data begins with a S) even after throwing it all into an apply to all, which I'd like to avoid.
 
 
So the first part is filtering the SharePoint list and that is then put into a Select (the if formulas are just to only show the dates that are expiring, otherwise they'll all come through) following that, it put it into a html table. 
 
 
I then check the length prior to sending an email but when the email comes through, there's only one entry on there when there should be two -- again, even when I put all of this into an apply to all, it still preformed the same)
 
email that comes through ^
 
SharePoint v
 
 
It's been a little while since I've played with flow and clearly I'm missing something and if any of you know, I'd be forever in your debt if you could help :) 
I have the same question (0)
  • stampcoin Profile Picture
    4,355 Super User 2025 Season 2 on 01 May 2025 at 13:05:20
    Array only pulling one entry
    @smather  Hi,
    Something wrong with your first step , the Odata query.
    you can remove the query ( you can export it for backup if you want to).
     
    add a Filter array after the first step( before select 60).
    below is an example I want to filter Order delivery date in coming 60 days.
     
     
    then this output feed your select 60.
     
  • smather Profile Picture
    56 on 01 May 2025 at 12:37:25
    Array only pulling one entry
    hi @stampcoin - thank you for replying! 
     
    So as it turns out, the Select 60 is only finding the single entry and not the other one, so even by changing the formula to formatDateTime didn't make a difference. The second entry isn't visible through the Odata query  --- doing this, I removed the first bit of the filter "RenewalinProgress ne 1" - which is currently selected on the dummy data; but that renewal in progress is only for one of the entries, I need it to bypass one of the expiries if it's selected, not all of them. Do you have any suggestions on how to resolve this?
  • stampcoin Profile Picture
    4,355 Super User 2025 Season 2 on 01 May 2025 at 12:19:57
    Array only pulling one entry
     Hi, 
     
    Please check your flow , upstream, If Select60 get expected result, go downstream check. if only one records.
    then check the Odata query part.
    check the addDays, don't use addDays(utdNow(),60), it will count hour and mins in.
    using something like :
    Expires ge '@{formatDateTime(utcNow(),'yyyy-MM-dd')}' 
    and Expires le '@{formatDateTime(addDays(utcNow(),60),'yyyy-MM-dd')}'
    
     
  • smather Profile Picture
    56 on 01 May 2025 at 11:44:39
    Array only pulling one entry
    Hi @stampcoin - without the condition, I still only get one single entry
  • stampcoin Profile Picture
    4,355 Super User 2025 Season 2 on 01 May 2025 at 11:32:56
    Array only pulling one entry
    Does the output is what you expected before the condition?
     

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

Quick Links

Responsible AI policies

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

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 725 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 396 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 339

Last 30 days Overall leaderboard