In UiPath Apps, I am working with a Data Service entity named
InputFiles. This entity contains two columns: File and Status. I have extracted the values of the File column for all records where the Status is “Not Received” and stored them in a List(Of String) variable.
Once the user uploads the missing files (those marked as “Not Received”), the corresponding records in the entity need to be updated, changing their Status to “Received”. Since the file names are stored in the list, I am using the File name as a reference to identify which records to update.
I need to update the Status of a record based on the File name. However, the UpdateEntityRecord function in UiPath Apps requires the Entity Record Id (GUID). Therefore, I need a way to retrieve the Entity Record Id from the Data Service based on a given File name (cell value), so I can update the appropriate record in the entity.
