SharePoint Integration not working correctly using PowerApps Links

(1) Share

Report

Posted on by RVoller

222

Hi,

I have a PowerApps to log Issues. The Powerapps is linked to a SharePoint list.

There is a need to access an Issue from both the SharePoint list and the Powerapp.

To do this, from the Powerapps - OnStart =

Set(varIssue,Value( Param("IssueID"))); 
If(varIssue<>0,Set(varEditFeedback,LookUp('Issues Register',ID = varIssue)));
StartScreen = If(!IsBlank(Value(Param("IssueID"))),IssuesForm_Edit,galIssuesScreen);
 
In the SharePoint list, I have updated the formatting of the column
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"target": "_blank",
"href": "='https://apps.powerapps.com/play/e/abe92fe7-cc45-e08f-9547-a494a0cbb2c4/a/29d0622e-900a-4f52-9034-074257aeb86675&IssueID='+[$ID]"
}
}
 
It looks likes this.
I have also integrated from the SharePoint list by using SharePoint-->Integrate-->Customise-->Powerapps forms--> and updated the OnStart with a launch function to the Powerapps.
OnNew for SharePoint Integration has the Launch statement as well.
Problem : 
When the app is played, the powerapps will default to the gallery screen.  This is correct.
When the app is played, and a user needs to edit a loan, the edit pencil can be selected. The Edit screen will be opened. This is correct.
When a loan is selected from the SharePoint list, the JSON code does not work and the powerapps does not open in edit mode, instead the gallery is displayed.
 
How do I get the details of the loan (loanDetailsScreen) to display when accessed from the SharePoint list.
So when the loan hyperlink is clicked, the powerapps should default to the edit page below and show all the details of the request and not the gallery.
Kind regards
 
 
Rene Voller
 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @RVoller,

You have a fundamental problem with Power Apps integrated forms - when they are closed they only close the visibility of the form (that is why you will see RequestHide() in the code). This is for performance reasons so the user does not have to wait for the form to open every time they select a new record. The only parameter that changes is SharePointIntegration.Selected (the chosen record) - App OnStart and StartScreen do not run, nor does any Screen OnVisible code unless the user refreshes their browser between each record.

If I am off-track on your issue, please let me know.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
RVoller 222 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Thank you for responding to my post. It proved immensely helpful in me understanding where the issue lies.

And I am very embarassed to say that I over-complicated a very simple solution.

All I needed to do was change the OnStart statement and it worked.

Set(varIssue,Value( Param("IssueID")));

If(varIssue>0,Set(varEditFeedback,LookUp('Issues Register',ID = varIssue)));

StartScreen = If(!IsBlank(Value(Param("IssueID"))),IssuesForm_Edit,galIssuesScreen);

I then made sure that the column formatting referenced the ID correctly.

Thanks for your support.

Kind regards

Rene Voller

Was this reply helpful? Yes No