I am trying to build an ODATA filter that checks if a value is present in a newly inserted list column entry after a PowerApp form submission that notifies my supervisor of an approval via MS Approvals.
I have 2 columns on my SharePoint List:
TR-ID has an auto generated entry and is connected to TRIDD_2 so that the ID numbers can be passed around and followed via an auto-increment formula I've implemented ("AA10-TRIDD_2-2022", an example would be "AA10-1234-2022") while TRIDD_2 is in charge of auto incrementing the ID itself (1234)
In my Power Automate "Get items" I want to get items only related to the newest entry based on the ID that I have received from the latest entry, example if I were to enter an new entry in the form my Flow would automatically know that the latest entry on the SharePoint List is that latest entry. My goal is to mitigate any possibility of wrongfully given user entries (if me and my coworker enter items into the Form, our managers should get our entries on the list via Approvals and not the other way around.)
What I'm trying to do is when the "Get items" is triggered to filter the TR-ID (AA10-1234-2022) with the TRIDD_2 (1234) and to get that exact file to be sent to the Approvals app for proper management of tasks and data entries.
And I'm stumped. I hit a brick wall and I'm down to using "ID desc" in my Order by however that has issues with getting wrongful information.
I am facing the issue where if more simultaneous users send an entry through the form that my filter with get the wrong entries in the list and apply them in the Approval portion of the flow, mainly trying to prevent the possibility of wrongly gotten list entries. That's why I'm thinking that an ODATA filter could help me resolve this issue.
The form users fill out is for submitting documents digitally or without any documents in case they deliver it to the office. The trigger is responsible for extracting documents as outlined in my screenshot (2nd and 3rd step).
If I take out the trigger, those two will not work:
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.