Write Submitting User's Department Upon Form Submission

%3CLINGO-SUB%20id%3D%22lingo-sub-2275190%22%20slang%3D%22en-US%22%3EWrite%20Submitting%20User's%20Department%20Upon%20Form%20Submission%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275190%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20new%20to%20PowerApps%20and%20am%20customizing%20a%20SharePoint%20list%20form.%26nbsp%3B%20When%20the%20user%20submits%20the%20form%2C%20I%20need%20it%20to%20look%20up%20their%20department%20in%20AD%20and%20then%20write%20that%20into%20a%20department%20field%20on%20the%20form.%26nbsp%3B%20Is%20that%20possible%3F%26nbsp%3B%20I%20see%20that%20I%20can%20replace%20the%20form's%20function%20for%20OnSave%2C%20but%20I've%20no%20idea%20how%20to%20do%20the%20look%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20side%20question%2C%20even%20though%20the%20form%20is%20writing%20the%20value%2C%20it%20will%20still%20show%20that%20the%20user%20modified%20the%20list%20record%2C%20correct%3F%26nbsp%3B%20I%20currently%20am%20using%20Flow%20to%20do%20the%20lookup%20and%20write%20in%20the%20department%2C%20but%20it%20shows%20my%20account%20as%20modifying%20the%20field%2C%20which%20causes%20issues%20for%20our%20auditing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2275190%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I'm new to PowerApps and am customizing a SharePoint list form.  When the user submits the form, I need it to look up their department in AD and then write that into a department field on the form.  Is that possible?  I see that I can replace the form's function for OnSave, but I've no idea how to do the look up.

 

As a side question, even though the form is writing the value, it will still show that the user modified the list record, correct?  I currently am using Flow to do the lookup and write in the department, but it shows my account as modifying the field, which causes issues for our auditing.

0 Replies