I have an existing InfoPath form that needs to populate a SharePoint Online list field based on the user's department. I found this article that walked through using a data connection to the User Information List but, even though the user name comes through, none of the other fields populate, so the department field ends up being blank in the list.
Does anyone know of a good way to do this with SharePoint Online?
Keep in mind that:
This is an existing form and, at this time, recreating it with Power Apps isn't an option for me.
I was using a Flow to successfully populate the field after the list item was created, but it then showed that my account modified the field, which turned into an audit issue.