Notifications
Announcements
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.
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
But can you please tell me, how should i do that? this video did not help me.This is another screenshot from that
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
That is Correct. Thank you. But where should i write that?
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.
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.
Can you please share a full screenshot of the app in the canvas studio?
Of course. Thanks in advance for the help
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.
Thank you very much for your Help
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
