Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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.
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |