You’re offline. This is a read only version of the page.
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!
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
Share
Report
All responses (
Answers (
5,727
