we are using a Sharepoint list in which employees can capture their expenses. We are using the [Me] filter on "Author" column to let the user only see his own entries.
Due to organizational reasons we had to create a new user for each employee, which means that we have "John Doe" with ID 123 and a second (the new one) "John Doe" with ID 456.
Of course User 123 captured a lot of entries which User 456 should see. User 123 won't be used anymore. Therefore I wrote a short RPA script to update the "Author" column in the Sharepoint list and replace the old "John Doe" through the new one. When opening the list and clicking on "Doe, John" the profile of the new user (456) opens - everything looks right at this point. Nevertheless, if the new John Doe is logging in he can't see these entries that were initially captured by the old user.
Any idea how to solve this? When I look at the CAML query (in Sharepoint Designer) which controls the view I cannot see any reason why the new user shouldn't see the entries where the Author column is also referencing this new user.
Thanks in advance!