Lookup photos based on list of Staff IDs in Excel file

(0) Share

Report

Posted on by PipManifold

184

Hi there,

I have a list of staff ids and I want to know if I have a photo of each staff member or not. We keep the photos in a SharePoint folder named as the id number and some photos also have the staff members name after it. The ID number is always at the beginning and is 7 digits long

I would love to create a Flow which can check for matches and if it finds one list the file path next to the staff number in my excel sheet.

I've started with the basics

- Button trigger

- List row present in table (Excel)

- List folder (Sharepoint)

However after than I'm a little stuck on how to pull out the ID number from the photo file name (get flow to ignore the .jpg or if the staff member name is also included) and match this to the Excel entry. I've tried to set up the file name as a string and then initialise variable with the expression

substring(variables('FileNameString'),1,7)

however it puts this in an apply to each loop and wont let me set up the second need initialise variable. I've also tried to use it directly in the condition field and it wouldn't validate.

Any suggestions?

Thanks so much

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Gristy 2,429 on at

Like (0)

Report

you cannot init a variable inside a loop, this needs to be at the top of the flow, you can then manipulate variables inside the flow no problem.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @PipManifold,

If you want to get these files names to create an array, you could refer to the following Flow structure:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

PipManifold 184 on at

Like (0)

Report

Hi Everyone.
Thanks for all your helpful advice. I've worked it out. Just has to get my head around how to feed the data back into my spreadsheet and realised this had to be triggered by what my initial query to find the file found.

Here is the Flow for anyone's future interest:
This program is to coordinate students as staff, which is why the matching identifier in this case is a student number rather than a staff number.

Was this reply helpful? Yes No