cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

Capture an email or phone call being sent from PowerApps

I have an app that users can send emails and make phone calls from.

 

What I'm wondering is, how can I capture that activity in a SharePoint list or Power BI?

 

Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

@buteaur 

Not necessarily, I would change the action completely to include it.

So, for example, you have an ActivityLog list with columns in it to capture what you want to capture.  Then in the Send for email button, something like the following:

...your send email formula...;

Patch(ActivityLog, Defaults(ActivityLog), 
   {ActivityTime: Now(), 
    ActivityAction: "Email",
    ActivityTo: yourSendToInformationHere
   }
)

And for the Phone button:

Patch(ActivityLog, Defaults(ActivityLog), 
   {ActivityTime: Now(), 
    ActivityAction: "Phone",
    ActivityTo: phonenumberinformationhere
   }
);

Launch("tel:" & phonenumberinformationhere)


 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Super User III
Super User III

@buteaur 

I'm not entirely sure why you are launching the telephone twice in your formula.

I would suggest that you preform the Patch to the list and then launch:

Patch(Client_LIST_3, 
    Defaults(Client_LIST_3),
    {  ActivityTime: Now(),
       ActivityAction: "Phone",
       ActivityTo: phonenumberinformationhere
    }
);

Launch("tel:" & phonenumberinformationhere)

Beyond that, is there any error or issue you are seeing? 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

13 REPLIES 13
Super User III
Super User III

@buteaur 

You could simply write a record to a list before you launch the action to send email or call.  That would be the only option as you can't discover activities outside of the app.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Thank you.  So, you are saying to have a "submit" button that captures the information before the "send" button is hit?

 

That was the idea I had as well so it sounds like I'm on the right track.  Correct?

 

Super User III
Super User III

@buteaur 

Not necessarily, I would change the action completely to include it.

So, for example, you have an ActivityLog list with columns in it to capture what you want to capture.  Then in the Send for email button, something like the following:

...your send email formula...;

Patch(ActivityLog, Defaults(ActivityLog), 
   {ActivityTime: Now(), 
    ActivityAction: "Email",
    ActivityTo: yourSendToInformationHere
   }
)

And for the Phone button:

Patch(ActivityLog, Defaults(ActivityLog), 
   {ActivityTime: Now(), 
    ActivityAction: "Phone",
    ActivityTo: phonenumberinformationhere
   }
);

Launch("tel:" & phonenumberinformationhere)


 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Resolver I
Resolver I

Awesome!  Thank you!

follow up question.  

 

Here is the start of my email function.  the Patch doesn't seem to be accepted.

Thoughts?

 

ffice365Outlook.SendEmailV2(TextInput3.Text, TextInput1.Text, TextInput2.Text & "<br>" & "<br>" & UserName.Text & "<br>"

Super User III
Super User III

@buteaur 

Can you show me this with the Patch part you added?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Resolver I
Resolver I

Quick question, in your patch, is activity log meant to be my log via SharePoint that I have to rename?

Super User III
Super User III

@buteaur 

That was just a made up name of the list.  You can call yours whatever you want and just change that and the column names I provided to whatever works best for your app.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Thank you.  I'm sure that's what I did wrong! I'll update and let you know.

Thank you again.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (21,064)