Skip to main content

Notifications

Announcements

No record found.

Power Platform Community / Forums / General / Filter Excel Table bas...
General
Unanswered

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

Posted on by 70

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:

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,662