Power Platform Community Forum Thread Details

Hello,

to provide a bit of context:

I have a PowerApp/PowerAutomate approval flow. The app is the interface with 5 dropdown menus, and the app communicates with the SharePoint List. All is published on SharePoint.
The purpose is that the users select the product trough the App via dropdowns, and press the button to send the selected product data and the requestor's data that has been collected by App via User().Email formula. The requesting user1, can be identified via User().Email formula, so that Power automate flow can get the user1-email from App.

New feature I want to build:

I want to allow user1, to fill the Power Apps on behalf of other user2. Which means that User().Email formula cannot be used to retrive the user2-email. Instead, user2-email has to be typed.
I have to enable autocomplete (or similar) in the TextInput control to suggest email addresses (or other user-property), in order to avoid typing errors.
The autocompletation has to retrive emails from the existing user-database of the company - the same that is used by User().Email formula, so that no additional SharePoint list has to be created.

Any suggestion on how to implement the autocompletation of the email?

Thanks in advance!

Categories:

Using Apps Using Formulas

Hey CU19090705-0,

I would just create a Second list with 2 columns maybe 3 depending on your needs

Column one = Employe name, Column 2 Employe email, possible Column 3 Department, possible Column 4 Level

The Column 3 and 4 are there to limit who can request on behalf of which user. Level could also be position or something like this.

then you could add a Dropdown to your app where you use the new list as Datasource.

If you choose to limit the posibilitys to request on Behalf of someone you would need to add a filter

With({UserData:LookUp('Employee list',User().EMail= 'Employe email')},
    Filter('Employee list', Department = UserData.Department, Level=<UserData.Level)
)

If this solvede your porblem please accept it as solution so others can find it as well.
If it helped in any other way consider liking it so we can keep supporting eachother.