Thank you. I have done something similar.
I have given each user their own row in the reference table as below
The Action below changes the delivery date to the corresponding row based on USEREMAIL().
Delivery Date = LOOKUP(USEREMAIL(), “Reassign Order Date”, “User Id”, “Change Delivery Date To”)
Another action creates a new row in the table if there isn’t one for the current user with this condition in the action to prevent duplicates.
NOT(IN(USEREMAIL(),Reassign Order Date[User ID]))
This works fine. I also have actions and workflow set up so that clicking one “change date” action button takes the user directly to reassign table/view for them to select the date. When they press save we return the previous view and the date is changed.
The problem I have now is that while the expression works to select the correct row based on USEREMAIL() to make the date change, I can’t get the view of the reference table to show the correct row in the view.
I have this as the LINKTOVIEW but it only ever shows the first row in the table even though the expression looks fine.
LINKTOFILTEREDVIEW(“Reassign Order Delivery Date”, [User Id ] = USEREMAIL())
As things stand only row with unique id “1” shows (and I’m firstname.lastname@example.org not Hilary)