I'm trying to do a filter in a table where the current user can only see their own records.
The records in the table only show the user who created the record as owner of all the records, this is because we were importing the records from excel.
I want to be able to reassign ownership of each record to individual users using their email addresses.
I have tried the below, but it is not working, any assistance will be appreciated.
I have tried the codes below on the compose action:
first(body('list_rows_2')?['value']?['systemuserid']) first(outputs('List_Rows_2'))['systemuserid']