Approval process Flow - Link to item does not display any data

[cpmhaitang]

Hi,

I am creating an approval process for when an employee requests a certain change to be made in a business dictionary:

1. User submits change request --> new item gets created in Sharepoint list with 'Pending' Status

2. Manager receives pending approval message with link to item

3a. Manager approves --> item updates Status to 'Approved'

3b. Manager rejects --> item updates Status to 'Rejected'

The issues I'm facing are:

1. The form to be approved by the manager shows none of the information filled-in by the user.
2. After approving, the Status column does not get updated to Approved or Rejected.
3. The manager receives an email with approval confirmation, but then afterwards gets another request for approval email.

Empty be approved form from "Link to item":

Flow:

Kind regards,

Charlie

[v-bofeng-msft]

Hi @cpmhaitang :

First,whether the manager can see the specified information depends on how you set the "Start an approval" action. The more common method is to set the "Item link" so that the manager can directly find the specified item through the Item link.

Second,you said "the Status column does not get updated to Approved or Rejected.".If the ‘Status’ column do not allow multiple selections, then your settings are correct.I addition,Please check the running history of your flow to ensure that your two update items have been executed correctly.

Third,The reason why the manager will receive multiple approvals is that your "Start a approval" is in a cycle of "Apply to each", and the number of approvals sent depends on how many cycles of "Apply to each" are executed.

Finally, here is the Power Apps forum. If you have any follow-up questions, please consider posting your question to the Power Automate forum.

Best Regards,

Bof

[cpmhaitang]

Hi @v-bofeng-msft,

Thank you very much for your reply. I have solved problems 2 & 3 by creating a new flow, using another template, with as trigger being a new item created in the Sharepoint list instead of a trigger from a Powerapps button.

As for problem 1, the item link was already correct. It referred to the item in the Sharepoint list, however, the cause is Power Apps related since the form does not show any of the details when I open it directly on the list.

Note that I have only made a form with default mode set to "New". I suspect this might have something to do with it.

Sharepoint list when opening the item: 

Power App:

[v-bofeng-msft]

Hi @cpmhaitang :

This may be a problem with the settings of your custom form.

I can see that you made a lot of custom settings for this form , so it's hard to tell where the problem is. I suggest that you can check the item attribute of form1. If it is not:

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@YourSPList]),SharePointIntegration.Selected)

I suggest you set it to 

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@YourSPList]),SharePointIntegration.Selected)​

Best Regards,

Bof

[cpmhaitang]

Dear Bof,

The item attribute was empty.

The solution worked for a while, but after I removed it, since it pre-populated the form when making a new entry, the problem occurred again.

I am new to Power Apps and am wondering if by default, this should not be the case.

Also, the item attribute I would like to keep reserved for a lookup formula I am going to use:

With({wList:Sort(Filter('KPI Book Change Request Form 2021 new',Status.Value="Approved"),Modified,Descending)},LookUp(wList,KPI=DataCardValue2.Selected.KPI)

Kind regards,

Charlie

[cpmhaitang]

Dear @v-bofeng-msft,

I have found that the SharePointIntegration was not referring to my form "Form1" but to the default " SharePointForm1". I expected to fix the problem with that, but now when I click on an item from the Sharepoint list, it is only showing " getting your data" while remaining stuck there. I then created quickly a new Sharepoint list with a new Power App form, and then something did appear. So is it the high degree of customization of my app causing this trouble? Ideally, I would like to have it in this current layout and format.

SharepointIntegration:

Opening a Sharepoint list item:

[v-bofeng-msft · Accepted solution]

Hi @cpmhaitang :

I suggest that you can modify the original custom form according to the new custom form you created.

(

• Check whether the properties of SharepointIntegration are consistent;
• Check whether the Item property of Form1 is consistent;
• modify if they are inconsistent

)

Best Regards,

Bof

[cpmhaitang]

Hi @v-bofeng-msft,

I've fixed the issue by keeping the customized form simple and starting the Flow from a 'new item added' in the Sharepoint list rather than from Power Apps submission. Thanks for your help.