Hello,
I have an issue about the searUserV2 and SendEmail V2 functions.
My app is a bit complicated and has several screens, I'll try to be clear :
- First screen : any user in the company can submit a new form to declare a problem. In this form, I put a Office365User.MyProfile().DisplayName function so that the current user doesn't have to write his own name. Let's take the example of "Bob"
(- When submitted, the forms' data fields, incl. User's name, are stored in an Excel table.) No problem for that.
- Second Screen : a few specific users (= "Jack") can fill a new form to answer to "Bob". In this second form there are two types of fields :
1) Bob's informations and question (incl. his DisplayName) : only displayed
2) Various empty fields to be completed by "Jack". (these new datas are also stored in the corresponding line within the Excel table ).
So :
When "Jack" submits his answer, I would like "Bob" to be sent an email with the informations provided by "Jack".
But the problem is that I only have "Bob" s Display name.
How can I get "Bob"'s e-mail adress, based on his DisplayName so that I can use the SendEmailV2 function when submitting the new form, and put in the e-mail's body new datas based on the fields that "Jack" has just filled ?
(please note I don't necessarily need the e-mail to be sent by "Jack")
I tried this in the button's OnSelect property :
SubmitForm(Form1_1);; Office365Outlook.SendEmailV2('Utilisateursd’Office365'.SearchUserV2({searchTerm:DataCardValue21.Text});Subject;Body)
It doesn't work and I think my formula is wrong.
Form is correctly submitted, but I have an error regarding the "SendEmail" function...
I thought i would perhaps better use a parallel PowerAutomate Flow instead of programming a new function in the app.
Could it be easier ?
Thanks a lot for your help.
Romain
