Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - General
Unanswered

Filter Excel Table based off of a "contains" search and output Asthetically pleasing

(0) ShareShare
ReportReport
Posted on by 508

I have an excel table in sharepoint that I would like for a user to search by specialty using a PVA bot.  So I would enter in lets say "Cardiology" and it would use maybe a contains function or maybe I would just force the user to pick it from a list.  Not sure havent gone that far yet but I want the output to more or less look like this for the user in the PVA agent window:

 

 

 

Cardiology - ElectrophysiologyTCC per Work RVU$49.86  $58.40  $64.36  $68.83  $80.08 
Cardiology - ElectrophysiologyWork RVU8,778.18  10,968.47  12,470.42  13,757.02  16,794.73 
Cardiology - GeneralTCC$401,834.58  $510,433.74  $571,741.85  $617,751.39  $751,259.10 
Cardiology - GeneralTCC per Work RVU$52.70  $63.16  $71.42  $77.62  $99.07 
Cardiology - GeneralWork RVU6,139.97  7,964.71  9,119.10  10,031.97  12,558.85 
Cardiology - Invasive - InterventionalTCC$507,848.58  $624,218.40  $704,190.77  $764,207.19  $951,264.21 
Cardiology - Invasive - InterventionalTCC per Work RVU$54.66  $63.90  $71.33  $76.91  $94.30 
Cardiology - Invasive - InterventionalWork RVU7,762.06  9,853.37  11,274.37  12,411.94  15,761.36 
Cardiology - Invasive - NoninterventionalTCC$492,120.26  $578,594.37  $648,513.00  $700,984.44  $818,250.31 
Cardiology - Invasive - NoninterventionalTCC per Work RVU$54.93  $64.45  $71.64  $77.04  $95.13 

 

The Benchmarking table.

VeeLearnMSFT_0-1652019232929.png

 

 

Here is what I have so far in the PVA bot flow.  Can someone please post an example of how I can do this properly?

 

VeeLearnMSFT_1-1652023163062.png

Right now my example is trying to filter for family medicine....here is how family medicine looks liek in the excel sharepoint table.

VeeLearnMSFT_2-1652023299936.png

 

Here is the output flow how it looks in the Apply to each section.  It separates the TCC, the TCC per Work Rvu and Conversion Factors.  

VeeLearnMSFT_3-1652023337459.pngVeeLearnMSFT_4-1652023354893.png

VeeLearnMSFT_6-1652023416720.png

 

I just dont know how to share this output with the PVA bot.  it comes out in like 3 differnet tables...I cannot figure it out.

 

Please help

 

Categories:

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Copilot Studio - General

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 76

#2
Pablo Roldan Profile Picture

Pablo Roldan 61

#3
stampcoin Profile Picture

stampcoin 10

Overall leaderboard