I am trying to delete an item from the SharePoint Doucment library using Flow.
We have a sharePoint list with employee informations and a doucment library with pdf files associated with each employee. We have , user id column in the document library against each pdf file.
We want to delet the pdf file associcatedwith a employee if he/she leaves the company. for that , I am creating a flow and checking the user last day column and compare it with today, if its greate than today , i will set the status as " Not in Company".
Now, I want to delete the associated file from the doucment library, How can i do that? I was trying to do this by checking the id column in the List and the userId column from the document library but, I dont know how to get the column name from the document library since I am getting the info(GetItem) from the list in the previous step.
Can anyone please help me? Let me know if you need more information.