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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Get a list or excel ta...
Copilot Studio
Unanswered

Get a list or excel table of remaining holiday - PVA Teams

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi there, 

 

I'm looking for a way to get just a number of remaining holidays from all employees. 

 

So if the HR ask the bot 'Remaining Holidays Employees' they can choose person X.

That works quiet well. 

 

So I create a flow in power automate:

 

laxvkr_0-1620825023436.png

 

If I run a test in Teams, the answer is just blank, but the action has a green hook. 

 

Maybe someone has an idea? 

 

 

 

Categories:
Calling actions from Copilot Studio
I have the same question (0)
  • CU22081450-0 Profile Picture
    CU22081450-0 Most Valuable Professional on at

    Hi @Anonymous ,

     

    It's a great use case! Congrats 🙂

     

    We have some limitations for Teams message using PVA. Today, we support some Markdowns.

    Use markdown to format Power Automate approvals - Power Automate | Microsoft Docs

     

    I recommend you to use it as a list with Markdown, instead of using an HTML table (you'll need to create an string variable, add an 'apply to each' action, and append to a string variable).

    Use markdown to format Power Automate approvals - Power Automate | Microsoft Docs

    E.g.:

    0. Renato

    0. Microsoft

    0. etc..

     

    Let me know if you have any questions.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 410

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 160 Super User 2026 Season 1

#3
chiaraalina Profile Picture

chiaraalina 63 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt
Welcome to the Copilot Studio forum!

Product updates

Microsoft Power Platform Community release plans