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
