Solved: Initial value instead of valid if - Page 2

Ellie_F · 03-22-2019 05:44 AM

Hi have a validif statement that filters the drop down dependant on the previous selection,
Select(Address Book[Recordid],[Usermail]=USEREMAIL())
this leaves me only one name to select from a list and that name is the name of the user (to link my two records)
HOWEVER what I want to do instead is have that as the initial value with no need to change it.
Is this possible and if so please could someone explain how ?
any help greatly appreciated.

LeventK

Hello @Ellie_F,
I have updated my sample app as well. Provided you had taken a copy of the sample app, just delete it completely, and copy it again. You will notice the below expression in the Initial Value of [CLIENT_ID] column in Sites table:

=LOOKUP(INDEX(ORDERBY([Related Jobs],[_RowNumber],TRUE),1),"Jobs","JOB_ID","CLIENT")

This will solve the problem. As the iFramed app under this post is updated, you can test the new enhancement from there also.

View solution in original post