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.
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
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!!
quot-Top-Count-quot/m-p/107996#M15606
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?
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
--------------------------------------------------------------------------
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
Hi, @eric-cheng
Thanks for your response. But the top count is default (all) and other field are blank now.
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