web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Creating a phonebook w...
Copilot Studio
Unanswered

Creating a phonebook within PVA

(0) ShareShare
ReportReport
Posted on by

Hello there, 

I wondered if anyone has had any success with using PVA to provide contact telephone numbers. I've had some success with creating entities of the relevant department/supplier names & then using questions within PVA to ask which department is required & then listing the number within a message response, this works well as there was only 10 or so telephone numbers needing to be provided.

However, I'm now looking to do something more extensive with a list of c100 department/supplier phone numbers. Would a Sharepoint list look up using an automate flow work better? Or any other suggestions?

Thanks,

Categories:
I have the same question (0)
  • Verified answer
    Monkeyman Profile Picture
    325 on at

    Hi,

     

    Yes, you could achieve this with a Sharepoint list. Or you could provision a Dataverse environment, and then use Power Automate to connect to Dataverse and search that to bring back what you need.

     

    Please mark this as accepted if you agree with the solution.

     

    Thanks.

  • Matthew5 Profile Picture
    on at

    Thank you @Monkeyman 

    I don't believe there's a way to create synonyms within SharePoint lists so we'd be relying on the user to correctly name the relevant department to then obtain the telephone number. 
    For the condition in within Automate, do you think there is an option which would provide greater success for variations in user messages? E.g will contain work best or starts with?

    Thanks

  • Monkeyman Profile Picture
    325 on at

    Yes I see. You could use contains. Then pass the result back to the chatbot, ask the user if that is what they meant and then store their search criteria in a separate column. You could then search both the name of the department and the search term to bring back better results. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 255 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 205 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 101 Moderator

Last 30 days Overall leaderboard