Skip to main content

Notifications

Power Automate - General Discussion
Answered

Get items failure - some data are missing.

(1) ShareShare
ReportReport
Posted on by 26

Dear all,

I’m utilizing Lists platform and RPA to track my work status, but I just run into some problems.
Goal : I manually update the information on Lists, and RPA can send stakeholders a progress report email every Monday. 

 

Screenshoot of Lists:

To exclude those approved item, only "Approval Received Date" is blank will be demonstrated. For example, 13 items are listed in this table.

ABT263_1-1632150407121.png

 

 

My RPA structure is like :

1. Recurrence (weekly)

2. Get items – ODATA Filter:ApprovalReceivedDate eq null "

3. ”Filter array (Choose a specific project)

4. Parse JSON --> Select --> Create HTML table
5. Send an email

 

Interestingly, I found some of items were not listed in the “Get items “ step, but I just still can't figure out the reason. Could any one help me?

 

Email screen shot: Only 5 items succeed, and the rest of items are missing

ABT263_0-1632150338524.png

 

  • Verified answer
    ABT-263 Profile Picture
    ABT-263 26 on at
    Re: Get items failure - some data are missing.

    @eric-cheng 

    With or without the filter, the total count are 100!

    It seems like, Get Items returns only 100 rows one time, and I can input "9999999" in Top Count to overcome the error. Thank you Eric for point out the problem!!

    https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-Get-Items-returns-only-100-entries-when-

    quot-Top-Count-quot/m-p/107996#M15606 

     

    ABT263_0-1632196513876.png

     

     

  • eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: Get items failure - some data are missing.

    Hi @ABT-263 ,

     

    Thanks.  How many records is in your list?

     

    Can you also try these two actions:

     

    1) Add compose after your Get Items, run it and check in the flow history how many items are returned?

     

    ericcheng_0-1632183775438.png

     

    2) Remove the filter, run it and check the flow history again.  How many items are returned now?  Can you find some of the missing records?  What is the value for ApprovalReceivedDate for these items?  

     

    Lastly, can you go to your Get Items settings and see if it similar to the below

    ericcheng_1-1632183933185.png

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

     

     

  • ABT-263 Profile Picture
    ABT-263 26 on at
    Re: Get items failure - some data are missing.

    Hi, @eric-cheng 

    Thanks for your response.  But the top count is default (all) and other field are blank now.

    ABT263_2-1632183368635.png

     

    ABT263_1-1632183123954.png

     

     

  • eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: Get items failure - some data are missing.

    Hi @ABT-263 ,

     

    Without seeing your flow, it will be hard to diagnose your issue.  It looks like the Get Items returned only the first 5 rows.  Do you have a top count in your step or another filter?

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard