Make Slicer a Variable to add to Power Automate

[motleyts2]

Hello. I have a slicer that has Line of Business (LOB) values (i.e., Medicare, Medicaid, Commercial, etc). How can I make this slicer a dynamic variable to use in Power Automate? In Power Automate, the value in the slicer (let's say it's "Medicare") will be added to the File Name in the Create File to Sharepoint action.

In summary, I need assistance with making a slicer a dynamic value that updates the File Name in the Create File action. So, if the user chooses "Medicare" or another value in the slicer, this value will be updated in the File Name in Power Automate as "PowerBIData_[LOB]_DateTime". The end goal is to create a CSV file with a dynamic File Name that updates based on the slicer value.

Thank you.

[christinepayton · Accepted solution]

Are you using the Power Automate visual, where you click the button to send it to PA? If that's what you're using, I would just put the field into the table visual so that when you click the button, whatever is selected in the slicer is sent along with the data to Power Automate by virtue of it also being in the table. If it's a single-select slicer, you can just get the first value with an expression on the Power Automate side. 

[motleyts2]

Thank you! I ended up creating a selected value of the slicer as a measure. Added the measure to the Power Automate flow values. Added a Compose action in the flow with the triggerbody expresssion. 

[Vishubest253]

I have same requirment in my project, so can u povide me more details to build this flow in Power automate

[christinepayton]

If I had to guess, it was probably a measure like SELECTEDVALUE( field name here). If you drop that in the visual you're displaying and in the Power Automate visual button fields well, it will be sent to Power Automate when someone clicks the button.