Power Platform Community Forum Thread Details

Hi!

I am wanting to create a flow for a recruitment spreadsheet.

Basically, I have a table set up in excel that adds rows into the table when I receive a resume via email - this resume attachment is then added into a specific folder.

The table looks like this:

Candidate Name	Status
John Doe	Not Suitable
Jane Doe	Interview

The candidate's name is pulled from the resume file name and after reviewing the resume, I manually update the status.

I am wanting to create a flow that when I manually update the status, it will then find the file in the folder, and move it to the "Not Suitable" folder.

It needs to be dynamic as the names are all different.

*Using SharePoint, Excel for Business, Etc. and not the premium triggers.

Thank you in advance!

Categories:

Power Automate Desktop

When the first process pulls down the resume and updates their name, it should retitle the resume to a fixed nomenclature, such as FName_LName_jobid.pdf or whatever. it should also put this filename in another column, so it can reference it.

I am pretty sure you can’t get “if cell changes, do something” but what you can do is ie

meithe have the bot help you when your going through resumes, or run the bot after you are done so it will go find the files and update the folder it is in.

With option 2 for example, you would have 3 candidates:

John Doe Not suitable John_Doe_12345678.pdf

Jane Doe Interview Jane_Doe_12345678.pdf

so this is when your bot picks up. Currently, both files are in your “Pending” folder and you want John to move to “Rejected” folder and Jane to move to “Interviews” folder.

read from Excel to %ExcelData%

for each %CurrentItem% in %ExcelData%
switch %CurrentItem[‘Status’]
Case Interview

Set variable %DestFolder% to Interview

Case Not suitable

Set variable %DestFolder% to Rejected

get files ending in %CurrentItem[‘FileName’] from %Path%/%JobID% (look in subfolders)

Move %Files[0]% to %Path/%JobID%/%DestFolder%
ebd (for each)

good luck