powerapp v2 flow - alternative for Loop

[namisrn]

Hi,
this is my first task regarding Microsoft Power App and don't know how I should solve it. We have a flow that in the input is entered email address and as output we should get back an ID. Both the files are in Database and basically , only the entered email address should be searched and corresponding ID should be output. What we have here right now is a loop. But a loop could lead to problems if we have multiple data. The question is, what could i use instead of loop that leads to the same answer.

[BCBuizer]

Hi @namisrn ,

This seems something you really don't need a flow for, but rather solve with a LookUp() or Filter() function in PowerApps:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

[namisrn]

But can you please tell me, how should i do that? this video did not help me.
This is another screenshot from that

[BCBuizer]

Hi @namisrn ,

As I understand you have a Dataverse table 'Benutzer' and you want to search the 'internalemailaddress' for a certain email address value and then return the ID value(s) for the corresponding records. Is that correct?

Something like the below will return a single column table that contains the ID values for all items that contain what is typed in TextInput1 in the internalemailaddress column of the Benutzer table:

Search(Benutzer, TextInput1.Text, internalemailaddress).ID

[namisrn]

That is Correct. Thank you. But where should i write that?

[BCBuizer]

Hi @namisrn ,

Probably instead of the code where you run the flow currently. However, I have no clue what your app does with this information so please explain in case you need more guidance.

[namisrn]

I have inserted it there but it does not work.
And the app is actually quite simple as you explained.
There is a single input field where you have to enter an email address. Then when you click Run, you get back an ID corresponding to that email which is in database. That's it.

[BCBuizer]

Hi @namisrn ,

Can you please share a full screenshot of the app in the canvas studio? 

[namisrn]

Of course. Thanks in advance for the help

[BCBuizer · Accepted solution]

Hi @namisrn ,

What you can do to simply things is to add a vertical gallery control and use the code for the Items properties. Then set the Text property of the Title label to ThisItem.ID and the Text property of the SubTitle label to ThisItem.internalemailaddress. 

Like this the gallery will update while the user is typing the email address and there is no longer a need for the buttons.