Build a URL and assign that to the WebURL part of a Button Action

[Anonymous]

I am building a generic reportfeed back tool. I would like it to be a single object that we can simply copy and paste into a new report without changing anything about the object itself.

It would construct a URL to a powerapps form and include parameters that describe the user, report, date and time, etc. so the user does not have to enter that information.

I know how to build such a URL.

The challenge is where to build it and where to put it so that it is a clickable URL. 

[Anonymous · Accepted solution]

I figured a way to do this.

It was a struggle and Power Bi fought all along the way.

1. Create a Spreadsheet containing the base URL of your Powerapps form.

2. Bring that in as a data source (I called it BaseURL and renamed the URL column from Column 1 to PowerAppURL)

3. Add a custom column and populate it with the name of your report. I called the column ReportName 

4. Create another custom column and concatenate the PowerAppURL with "?P1"& ReportName . "P1" is the parameter name...use whateve you want. It just need to be connected in the Powerapps form. I called this column "Link". Very imaginative, I know

5. Now create a measure:

LinkWIthUser = CONCATENATE (

SELECTEDVALUE ( 'BaseURL'[Link] )&"?P2=",

USERNAME()

)  I called this measure LinkWithUser

You have to do this because you can't use the DAX command Username() in a calculated column.

 So now you end up with a measure in your link to your form, with the report anme and user is parameters in it.

Now you can use a Button and in the Action attribute, set Type to URL and in Web URL, select the Fx and pick the column LinkWithUser

Hopefully MS will clue in and provide some kind of Reflection functionality so you don't have to juryrig this stuff. It would be nice to be able to use a variable in the Web URL or to have actual "Fuction" functionality to build the URL.

[Anonymous]

OK. I need to invert this post. I have a solution for dsiplaying and making the link clickable.

But damned if I can figure out how to embed the Globals.xxx data into a measue. I know these re not available until the report is deployed to the server but Power Bi Desktop insists that they be available. Adding them and saving in the hopes that they will work on the server does not work.

Everything seems to be a catch 22.

Ideas?

[Anonymous · Accepted solution]

I figured a way to do this.

It was a struggle and Power Bi fought all along the way.

1. Create a Spreadsheet containing the base URL of your Powerapps form.

2. Bring that in as a data source (I called it BaseURL and renamed the URL column from Column 1 to PowerAppURL)

3. Add a custom column and populate it with the name of your report. I called the column ReportName 

4. Create another custom column and concatenate the PowerAppURL with "?P1"& ReportName . "P1" is the parameter name...use whateve you want. It just need to be connected in the Powerapps form. I called this column "Link". Very imaginative, I know

5. Now create a measure:

LinkWIthUser = CONCATENATE (

SELECTEDVALUE ( 'BaseURL'[Link] )&"?P2=",

USERNAME()

)  I called this measure LinkWithUser

You have to do this because you can't use the DAX command Username() in a calculated column.

 So now you end up with a measure in your link to your form, with the report anme and user is parameters in it.

Now you can use a Button and in the Action attribute, set Type to URL and in Web URL, select the Fx and pick the column LinkWithUser

Hopefully MS will clue in and provide some kind of Reflection functionality so you don't have to juryrig this stuff. It would be nice to be able to use a variable in the Web URL or to have actual "Fuction" functionality to build the URL.

[Anonymous · Accepted solution]

I'd like to propose an even easier solution.

1. Click Enter Data on the visual page menu.

2. Enter some text.

3. Rename the table

4. Load

5. Add one measure.

FeedBackLink = "https://apps.powerapps.com/play/33d757f2-63e5-4cef-89bb-55be6fb5b10g?tenantId=9r633003-a081-4dfb-a63... Test?P2="& username()

I was obsessed with getting data from Power Bi. But you can't. You do, however know the URL to the from and in this application it will never change. You also know the report name since you are building it. Finally, the user name you can get since it's a measure.

One fake table and one measure that you can refer to in the formula for the WebURL in a button.