Update SharePoint column base another column value

[MeshanMilinda]

Hi, 

please help me to resolve this situation. 

I have Two SharePoint List as follows. 

1. IT Help Center

2. Issue Category

I need to when creating a new item in the IT Help Center list based on the Issue Category in IT Help Center auto-assign Person base Issue Category List. please see my Both List Screenshots. 

[alaabitar]

Hello,

Bascially you create a power automate flow that is triggered when a new item is create in the IT help Center shareepoint list. Then based on the issue category you get the corresponding item from the Issue Category list and update the Ticket Assignee column base on the AssignTo column value.

Best regards,

Alaa

[MeshanMilinda]

Hi @alaabitar 

i am new to power automation. can you explain this?

[alaabitar]

Yes of course. So first thing to do is to create a power automate flow that is triggered once a new item is created in the IT Help Center sharepoint list, this is what you have done. Then You need to add another action and select the get item from sharepoint component, from here you select the item that has Title = Issue Category and then you add an update item from sharepoint component and you update the Ticket Assignee to the Assign To.

If you need more details please let me know and I will create the two list and the hole flow in my test environment and share it with you.

Best regards,

Alaa 

[MeshanMilinda]

Hi @alaabitar 

I tried it. but it didn't work. I think my knowledge is very poor🤔. can your share with me how to do it. i really appreciate your support.