I’ve a CSV of person e-mail addresses and EIDs in a SharePoint doc. I even have an inventory I am constructing that can hopefully reference it. What I am making an attempt to perform is,

When a person goes to fill out the shape on the talked about checklist, the person will enter an e-mail handle in to a folks picker. After the folks picker resolves the suitable e-mail handle from AD, there’s a MS move that can both mechanically be triggered or a button {that a} person can press that can launch stated move or API request.
The request would parse by means of the CSV within the doc library, in search of the e-mail that matches the one entered in to the shape. Upon discovering the e-mail handle it might populate the EID discipline that corresponds with it. (pulling the EID primarily based off the e-mail and populating the shape with stated EID.

I understand how to get file properties and content material utilizing MS move, I understand how to make use of the replace motion to fill in fields. What I am lacking is easy methods to get MS move to tug the knowledge I am in search of from the CSV.

The move must reference the folks picker e-mail discipline, whereas nonetheless within the kind.
How do I get MS move to take the entered Electronic mail handle > search the CSV for the matching e-mail handle > and return the quantity within the EID column subsequent to it in to a specified discipline?

STEPS I’M TRYING

1. Create a PowerApps kind
2. After the e-mail discipline have a button that can launch the request to gather the EID from the CSV
3. In MS move there can be an motion that may be manually or mechanically began.
4. SP ACTION that appears within the Electronic mail discipline and shops what was entered
5. SP motion that will get CSV content material
6. (the exhausting half) Taking that saved e-mail and looking out by means of the CSV for matching e-mail
7. As soon as discovering matching e-mail > gather EID
8. SP UPDATE ACTION that updates the EID discipline on the shape with collected knowledge.

It is the small print within the center the place I am getting misplaced.

If there’s a higher or extra environment friendly approach to do that, please let me know. Thanks on your assist upfront.