Answered

powerapp v2 flow - alternative for Loop

Like (0) Share

Report

Posted on 6 Oct 2022 12:59:48 by 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.

Categories:

General Questions

testttt.png

I have the same question (0)

All responses (10)

Answers (1)

namisrn 18 on 07 Oct 2022 at 08:28:36

Like (1)

Report

Re: powerapp v2 flow - alternative for Loop

Thank you very much for your Help

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,317 Super User 2025 Season 2 on 06 Oct 2022 at 14:28:14

Like (1)

Report

Re: powerapp v2 flow - alternative for Loop

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.

Was this reply helpful? Yes No
namisrn 18 on 06 Oct 2022 at 14:14:09

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

Of course. Thanks in advance for the help

Screenshot 2022-1...

Was this reply helpful? Yes No
BCBuizer 22,317 Super User 2025 Season 2 on 06 Oct 2022 at 14:09:16

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

Hi @namisrn ,

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

Was this reply helpful? Yes No
namisrn 18 on 06 Oct 2022 at 14:03:19

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

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.

scrsht.png

scnsht2.png

Was this reply helpful? Yes No
BCBuizer 22,317 Super User 2025 Season 2 on 06 Oct 2022 at 13:56:17

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

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.

Was this reply helpful? Yes No
namisrn 18 on 06 Oct 2022 at 13:51:19

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

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

Was this reply helpful? Yes No
BCBuizer 22,317 Super User 2025 Season 2 on 06 Oct 2022 at 13:37:11

Like (1)

Report
Re: powerapp v2 flow - alternative for Loop

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

Was this reply helpful? Yes No
namisrn 18 on 06 Oct 2022 at 13:14:59

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

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

Screenshot 2022-1...

Was this reply helpful? Yes No
BCBuizer 22,317 Super User 2025 Season 2 on 06 Oct 2022 at 13:05:30

Like (0)

Report

Re: powerapp v2 flow - alternative for Loop

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

Was this reply helpful? Yes No