web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calling a phone number...

Power Apps

Answered

Calling a phone number that corresponds to the current week on a Sharepoint calendar

(0) Share

Report

Report

Posted on by sec4zj

45

Hello!

We have a schedule kept in a Sharepoint list of who is "on call" for each week of the year. We are trying to make a PowerApp with a quick call button that will call the person who is on call for that week based on the date. How can we get the PowerApp to pull the correct phone number for that week?

Currently, we have a Sharepoint list with two columns, Week Commencing (the Monday date for the week the person is on call) and

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

LookUp(SharepointList, OnCallDate = DateAdd(Today(), -1 * (Weekday(Today(), Monday) - 1), Days)).PhoneNumber
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@sec4zj,
Based on the issue that you mentioned, do you want to capture the phone number of the person who is on call for the current week?
Could you please share more about your scenario, more details about the SP list columns?
@cds provides a direction where assumes that you have an SP list where you have a PhoneNumber column and a Date column. What I want to confirm is, if there is a PhoneNumber column or just a Person column.
If it is a PhoneNumber column, you can try the formula @cds provided. What's more, I advise you to add a Gallery to display the record. The LookUp() will filter the PhoneNumber you want. Besides the PhoneNumber, you can add a button and set the OnSelect property as below to call the person on call this week.

Launch("tel:"&Field)

If it is a Person column, you should first get the corresponding phone number to the person through the Office365 connector. In general, we use the following formula to get the phone number.

Office365Users.UserProfile(InfoAbout.Text).mobilePhone

Best Regards,
Qi

Join the conversation