Power Platform Community Forum Thread Details

I tried various options from the web and with limited programming background ... frustrated, aggravated, and intimidated ... I decided to look for advice from the good, old forum 😞

I have a SP List where the "Linked cell" is a hyperlink to open the selected record on the list on the selected PowerApp screen (e.g. when click on the link at ID# 3, it should open Screen 2, with the data from ID# 3 displayed in edit mode:

"Status" is a calculated column "=IF([Parent entry]="aaa","Screen1","Screen2")"

"Link cell" is a text column where I tried various json without any success

The canvas App looks like this (I tried adding a Gallery and link through it, it didn't work, and I removed it):

If this is an achievable scenario, I need help with the:

- json on the List and

- proper settings for the Screens and Forms in the PowerApp

Thank you for reading the post / Thank you a lot for providing some advice

Categories:

Building Power Apps

To create a deep link from a SharePoint List to a specific screen in a Power App with the corresponding data displayed, you can follow these steps:

Define a column in your SharePoint List to store the deep link URL. This column should be of type "Hyperlink or Picture" or "Single line of text."
In the calculated column you mentioned ("Status"), use the following formula to construct the deep link URL based on the selected screen:

=IF([Parent entry] = "aaa", CONCATENATE("https://web.powerapps.com/apps/your-app-id?screen=Screen1&ID=", [ID]), CONCATENATE("https://web.powerapps.com/apps/your-app-id?screen=Screen2&ID=", [ID]))

Replace "your-app-id" with the actual ID of your Power App. This formula will create a URL that includes the app ID, the desired screen name ("Screen1" or "Screen2"), and the corresponding record ID from the SharePoint List.
Save the calculated column and ensure that the deep link URLs are correctly generated for each record in the SharePoint List.
In your Power App, on the screen you want to open when the deep link is clicked, add the OnVisible property with the following code:

If(
 !IsBlank(Param("ID")),
 Navigate(Screen2, Fade, {ID: Value(Param("ID"))}),
 Navigate(Screen1, Fade)
)

Replace "Screen2" and "Screen1" with the actual names of your screens in the Power App.
On the Screen2 (or whichever screen you want to display the record data), set the Item property of the form or controls to the following code:

LookUp(SharePointList, ID = ThisItem.ID)

Replace "SharePointList" with the actual name of your SharePoint List.
Publish the Power App.

Now, when you click on the hyperlink in the SharePoint List, it should open the corresponding screen in the Power App with the data from the selected record displayed. If the deep link is clicked while the Power App is not open, it will open the Power App and navigate to the specified screen with the data.

Note: Make sure you replace the placeholders (such as "your-app-id" and "SharePointList") with the actual values from your environment.

I hope this helps! If you have any further questions, feel free to ask.