-
okay i will study it and thanks a ton for your time today Hilary. This one was just giving me a tough time. I am truly grateful for the time you spent helping me figure this out
-
Here is a copy of your form with the same change that worked in my Office 365 site.
-
I took your form, changed the form load rule that sets manager to set the manager field to exactly the formula I listed. I updated the data connection to point to my Office 365 site & published. Attached is a screenshot of the result. I'll make the same change in your form for you and attach to another reply.
-
Ive tried all different variations. The one you just used as an example returns nothing. if i dont use the substring function then it returns the manager email with the i:0#.f|membership| in front of it. Attached is latest version of form. Everything else is working perfectly.
-
I am looking for an MVP who can spend 15 minutes of share time on my screen or follow along with me on my form to troubleshoot one bugger of an issue. If anyone knows such a person please let me know as this is a stopping point in my project.
-
Okay, so in general, that's what I'd expect to work. Where is this formula being used? When you set the Manager field from the Form Load rules? Actually, probably not - since you'd use substring-after(Value[Name = "Manager"], "i:0#.f|membership|") if you were using this in your form load rules where you set ...
-
the formula I am using to try and get just the email string is this:
substring-after(Manager,"i:0#.f|membership|")
-
In the data source task pane, find the data connections you are interested in. Drag the fields onto the form. Add a button that runs the query for the data connection. Publish the form so you can do your testing in the browser. Open the form. Enter values in query fields and click the button you have added to execute the query. I am recommending ...
-
how would i do what you are recommending here?
-
please reference newly uploaded file. When you publish or run it you see that the manager field is two substrings. One the email and the other the federation string. I tried using substring after but it did not work. Is their a document on how to get the manager s name of the user that is queried with the userprofile services. I dont even mind the ...