Hi @syhrh,
If you want to update the Approval Type column after the request is created in Leave Request List, you can use Power Automate.
Please find below the steps:
Create flow on your Leave Request List
1- Trigger: When an item is created (SharePoint)
2- Store the Requester Email in the variable.
3- Initialize variable to store Approval Type value from Employee list.
3- Use the Get Items action to fetch the data from Employee List based on Requester name
Filter Query : Name/EMail eq '@{variables('Requester Email')}'
4 - Store the value of Approval Type in variable
5- Update back the value in Leave Request List
Site Address: Select the Site URL in which we want to perform actions
Method: PATCH
Uri: _api/web/lists/getbytitle('Your List Name')/items(itemID)
Headers:
{
"content-type": "application/json;odata=verbose",
"IF-MATCH": "*"
}
Body : RequestBody
{
"__metadata": {
"type": "SP.Data.Your List NameListItem"
},
"Column Internal Name": "@{variables('Approval Type')}",
}
Thanks,
vivek
If this post helps answer your question, please click on "Accept as Solution" to help other members find it more quicky.
If you thought this post was helpful, Please give it a thumbs up.
