Announcements
Oh the value in list 1 is input from powerapps
Did you specify the column that you wanted to return from your lookup like this?
Lookup(List2, Department = List1.DIV/DEPT).AdminName
Where should i specify this?
That depends on how are you are trying to use it. Are you trying to set the value on the screen in a PowerApps application or are you just trying to set the value in a SharePoint list? You said there is a PowerApps application in which the value in List1 is being entered. When it is entered, what do you want to have happen?
When the user enter the DIV i want to get the admin name and email from the List2. Im trying to send an email to the admin when new record is added.
In that case I would set a global variable to the result of this lookup. Depending on how your input control for DIV/DEPT is set up you can probably set the variable either in the OnChange property or attached to a button if you are using one to save the DIV/DEPT. Syntax is Set(variablename, what you are setting the variable to),
in this case the lookup I provided above.
Just a thought, you could also do this with a flow set up with a trigger on when a new record is added.
Yes i have thought of using flow to do this but i stuck at the get items part as i cannot understand how to tell the system to retrieve the admin name from list 2 where DIV/DEPT = "Department" to list 1. So now im trying do both from powerapp and also automate.
Hi i have done the code and fixed the error warning but the name are still not appear in the sharepoint list. It would be great to have some help from you.This is the code in my powerapps.The primary list receive nothing.
I see both a SubmitForm and a Patch. Is the Patch updating the same date or additional data beyond what the SubmitForm is handling? The syntax of your Patch seems strange. If you are trying to update an existing record, the syntax would be Patch(eLeaveApp, First(Filter(eLeaveApp, <an expression to locate the record you want to update>)), { list of fields and values like you have for DateApply}) I don't understand what the 4 variables between Patch(eLeaveApp, and the opening curly brace are. Here's the documentation on Patch showing the correct syntax to either create or update. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
Ouh I see where my errors are now thanks.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 325 Most Valuable Professional
11manish 165
MS.Ragavendar 88 Super User 2026 Season 1
