cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VeeLearnMSFT
Post Patron
Post Patron

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

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

 

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Top Solution Authors
Users online (1,921)