Validating data and assign approval

[GeorgeSopra]

Hi all, 

I'm having a bit of a nightmare with this flow. Essentially, I need to do the following: 

1. capture access requests (Forms) thats the easy bit

2. Put that info into a database (sharepoint list) done that

3. Validate the existence of that number in a secondary database that includes an email address assigned to that number

4. Create and assign the approval based on the email address that is linked to the number submitted by the user. Example Customer enters value "1" which is joe@blogs.com. The approval then needs to be assigned to joe blogs. 

Any advice on how to execute this would be amazing. ChatGPT wasn't giving me what I needed lol

[David_MA]

So your secondary list is something like:

Number	Email
1	joe@blogs.com
2	sally@blogs.com

If so, use a get items action on the secondary list and use a query filter where the number field equals the number entered by the customer. Then use the length expression to check that it found a least one item. If it finds at least one item, you can then send the approval using the e-mail from the found items.

To ensure only one item can be found, make sure the number field is unique in your list. Since you are using a get items action, when you go to create the approval, it will want to put it into an Apply to each, which is fine. You just have to trust that since you made the number field unique only on item can be returned. 

[GeorgeSopra]

Thanks David. Is there any chance you could show me a visual? I'm more of visual person so would find this really beneficial