When there is a change in owner for an app, we can go into the management console to change. However if we need to change all the app for multiple owners to another, it will be tedious to do it one by one. One solution is to use Qlik Application Automation to automate the change
First, I created a google sheet that contains the pair of the change: list of old email and new email.
![Edy_Tan_0-1667445104989.png Edy_Tan_0-1667445104989.png](https://community.qlik.com/t5/image/serverpage/image-id/92764i98F4EC1306816466/image-size/medium?v=v2&px=400)
I used the Get Data from Sheet block to read the old email and new email
![Edy_Tan_1-1667445301175.png Edy_Tan_1-1667445301175.png](https://community.qlik.com/t5/image/serverpage/image-id/92765i65FCC454F5E737E5/image-size/medium?v=v2&px=400)
Next I used the Search Users block to retrieve the user ID based on the email for both the old and new email
![Edy_Tan_2-1667445390716.png Edy_Tan_2-1667445390716.png](https://community.qlik.com/t5/image/serverpage/image-id/92766i2FE534315F6A645D/image-size/medium?v=v2&px=400)
Then I list out all the apps using the List Items block with ResourceType = app
![Edy_Tan_3-1667445434460.png Edy_Tan_3-1667445434460.png](https://community.qlik.com/t5/image/serverpage/image-id/92767i04C90036F5B2EF4E/image-size/medium?v=v2&px=400)
![Edy_Tan_4-1667445486307.png Edy_Tan_4-1667445486307.png](https://community.qlik.com/t5/image/serverpage/image-id/92768i604E65A7AD3CD03F/image-size/medium?v=v2&px=400)
Then I use the condition block to check if app Owner ID matches the user ID of the old email
![Edy_Tan_5-1667445635201.png Edy_Tan_5-1667445635201.png](https://community.qlik.com/t5/image/serverpage/image-id/92769i4E7CA54BDAA8A55A/image-size/medium?v=v2&px=400)
If it matches then update the owner using the Update App Owner block
![Edy_Tan_6-1667445710889.png Edy_Tan_6-1667445710889.png](https://community.qlik.com/t5/image/serverpage/image-id/92770i0605247B7B85E4C5/image-size/medium?v=v2&px=400)
Set the Owner ID based on the output of the Search User block to the application whose App ID based on the output of the List Items block
![Edy_Tan_7-1667445752175.png Edy_Tan_7-1667445752175.png](https://community.qlik.com/t5/image/serverpage/image-id/92771i543ED8FBE3469053/image-size/medium?v=v2&px=400)
The following is the entire flow of the Qlik Application Automation
![Edy_Tan_8-1667445864291.png Edy_Tan_8-1667445864291.png](https://community.qlik.com/t5/image/serverpage/image-id/92772i558CC0FD7F19A67C/image-size/medium?v=v2&px=400)