Context: I use two flows to collect, aggregate, and provide a progress table for a teams' training hours. The first flow is working fine, where the team member provides their latest training record information to a Microsoft Form and the responses are aggregated into a SharePoint List along with all responses from the entire team.
When the new response is added to that SharePoint List, it kicks off the second flow with the "When an item is created or modified" trigger. This second flow then has the "Get items" action, which filters the SharePoint List by whatever the employee ID is from the latest submission and sends an email with their year-to-date submissions.
Problem: For the second flow, I keep seeing the "Get items" action not include the most recent item that triggered the second flow (with "When an item is created or modified"). I checked and the "Get items" action doesn't have any threshold and the amount of items it's pulled when filtered is all different amounts - from 1 item to 15+ items. It also says the flow succeeded, it doesn't seem to recognize that something is going wrong between the trigger action to the "Get items" action. What am I missing and why could these new items be excluded from the "Get items" action?
Thanks!
*Edit to add: The new items created from the first flow are correctly appearing in the SharePoint list - they are all formatted correctly so they could appear in the filtered list in flow #2*
