Answered

Building a form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm trying to build a powerapp form where managers can fill in data about their teammembers. I have a list with three columns: manager, teammember and answer (= the thing they have to fill in). So if a manager has two teammembers there will be two records in there with that manager's user object and with an empty answer. If a manager has already answered the form about each teammember, I don't want anything to pop up.

I'm trying to preload the form by putting 'Lookup('listname',Manager.Email=User().Email)' in the Item field. But it just returns 'no data found'. Even if I replace User().Email with the actual email address.

So I thought, this doesn't work, second option: I let them add new items to the list by making the form default 'new' and preloading my manager object to the current user, but that doesn't work either.

Thanks for helping out!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

R3dKap 1,594 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,
A few screen shots and a little bit more details about your lists would be welcome to understand better your goal here.
Are you making an App that uses SharePoint datasource or are you customizing a SharePoint list forms ?
In the meantime, a few remarks about some aspects of our post...
Firstly, when comparing email, be sure to use the Lower() function to make sure capital letters won't prevent from getting results.
Secondly, when dealing with the User() function, since every call to it will trigger a request, first load the current user inside a global variable in your OnStart event like the code below, and then use that variable whenever you need it in your app:
Set(CurrentUser,User())
Waiting for your feedback on more details and screen shots...
Emmanuel

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @R3dKap,

I started off just customizing a list form, but then changed to creating a custom app with that same list as datasource. So that's where I am right now.

Adding the function Lower around Manager.Email actually works if I hardcode an email address in the lookup inside the 'Item' field for the form.

I've added the set(curentUser,User()) to onstart. And this is the lookup I have for my 'Item' field: Lookup('mylist',Lower(Manager.email) = Lower(currentUser.Email)). Remember if I hardcode an email address here it works, but in this case the app just says: 'getting your data' and it seems to be stuck there.

Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I just found out that my user email is not equal to the email I have in the user objects in my list. Had to be the explanation I guess.

Thanks anyway!

Was this reply helpful? Yes No