The best way would be to create one automation per Assignee field you have I think. If you're hitting the automation limit, you could try creating one "Last Modified Time" field per "Assignee" field and using a formula field to determine which field got updated, but this wouldn't work correctly if multiple Assignee fields are updated in quick succession I'm afraid
Hi,
is it User field type? Or it's just an address in text format (or email)?
In short, you can add formula field like "Last entry":
IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign1),assign1) &
IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign2),assign2) &
IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign3),assign3)
Hi,
is it User field type? Or it's just an address in text format (or email)?
In short, you can add formula field like "Last entry":
IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign1),assign1) &
IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign2),assign2) &
IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign3),assign3)
Thank you for your reply! I use "User" field type.
I added your formula and I can get "User" field's displayed name. When I want to get user email, how should I change your formula?
Thank you for your reply! I use "User" field type.
I added your formula and I can get "User" field's displayed name. When I want to get user email, how should I change your formula?
I don't think it's possible to retrieve by formula
But you can do the trick with automation.
Change formula to output number of Assignee (1...3)
IF(assign1,IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign1),1)) &
IF(assign2,IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign2),2)) &
IF(assign3,IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign3),3))
additional IF added to avoid output when modification is delete value
I guess you should add conditional logic, to execute further steps only when number is not empty.
then you add script step, using all three emails as input data, select one according to number and output it as 'email_last'

you can use it then in further steps.
(Note: in script, I had to add "num" at the array beginning as in JS arrays are zero-based, [0,1,2,3].
if you don't have an idea what it means, just ignore 🙂 )
That's the case, where Idea by @kuovonne might bring an easier solution. If you had a possibility to format first formula as User, you could use it in further steps with all data including email address
I don't think it's possible to retrieve by formula
But you can do the trick with automation.
Change formula to output number of Assignee (1...3)
IF(assign1,IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign1),1)) &
IF(assign2,IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign2),2)) &
IF(assign3,IF(LAST_MODIFIED_TIME(assign1,assign2,assign3)=LAST_MODIFIED_TIME(assign3),3))
additional IF added to avoid output when modification is delete value
I guess you should add conditional logic, to execute further steps only when number is not empty.
then you add script step, using all three emails as input data, select one according to number and output it as 'email_last'

you can use it then in further steps.
(Note: in script, I had to add "num" at the array beginning as in JS arrays are zero-based, [0,1,2,3].
if you don't have an idea what it means, just ignore 🙂 )
That's the case, where Idea by @kuovonne might bring an easier solution. If you had a possibility to format first formula as User, you could use it in further steps with all data including email address
Thank you for your suggestion. I'll try it the way you suggested. 😊