cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Julien2
Post Prodigy
Post Prodigy

Person or Group changes to different value

Hello,

Recently, I have customized a form of a SharePoint list using PowerApps.
I have a button in this list only appears on Popup visibility either if the selected form is "Edit" that sends an email and runs a flow at the same time.
The flow will only update the "ManagerSignature" column to "Signed".

I have chosen for all the columns in the "Update Items" action to "Ask In PowerApps" from Dynamic content, and I have set all the Datacard variables for the button flow. 
Capture.PNG

The problem is after I submit, the "Managers"(Person Or Group) column changes to another email knowing that it should remain the same as it's created.

Please have a look at this demo below:

Demo1.gif
It's strange why it changes to another person since I have set for this Datacard the following: (The last column is the "Managers Claims").

 

'PowerApp->Updateitem'.Run(SharePointIntegration.SelectedListItemID,Destination_DataCard1.Default,Department_DataCard1.Default,'Trip Start_DataCard1'.Default,'Trip End_DataCard1'.Default,'Estimated Cost_DataCard1'.Default,'Trip type_DataCard1'.Default,Managers_DataCard1.DisplayName)​​


I have another question, is it possible to not use the flow and update "ManagerSignature" column to "Signed" after they select this button? If yes what would be this solution? (By default on "New Form" this column is hidden so it will be blank once it's created).

 

Can please someone explains in detail and provide an example of what could be the issue for this DataCard?

Any help will be greatly appreciated.
Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Julien2 ,

Could you please share a bit more about your scenario?

Do you want to update the ManagerSign column using Power Automate flow?

 

Based on the formula that you mentioned, I think there is something wrong with the value you provided for the Managers Claims field within the "Update Items" action.

 

I have made a test on my side, please consider modify your formula as below:

'PowerApp->Updateitem'.Run(
                           SharePointIntegration.SelectedListItemID,
                           Destination_DataCard1.Default,
                           Department_DataCard1.Default,
                           'Trip Start_DataCard1'.Default,
                           'Trip End_DataCard1'.Default,
                           'Estimated Cost_DataCard1'.Default,
                           'Trip type_DataCard1'.Default,
                            SharePointIntegration.Selected.Managers.Claims   // Modify formula here
)​​

Please take a try with above formula, then check if the issue is solved.

Note: The Managers_DataCard1.DisplayName formula would return the Display Name (e.g. "Managers") of the Managers field within your Edit form rather than selected value within the ComboBox.

 

In addition, based on the needs that you mentioned, I think it is not necessary to launch/fire a flow to update the current selected item. As an alternative solution, you could update the selected item within your custom form app directly.

Set the OnSelect property of the "Update Signature" button to following:

Office365Outlook.SendEmail(.....); // Type formula to send email
Patch(
       'Your SP List',
       SharePointIntegration.Selected,
       {
           ManagerSign: "Signed"
       }
)

or

Office365Outlook.SendEmail(.....); // Type formula to send email
UpdateIf(
       'Your SP List',
       ID = SharePointIntegration.SelectedListItemID,
       {
           ManagerSign: "Signed"
       }
)

 

Please take a try with above solution, check if the issue is fixed.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @Julien2 ,

Could you please share a bit more about your scenario?

Do you want to update the ManagerSign column using Power Automate flow?

 

Based on the formula that you mentioned, I think there is something wrong with the value you provided for the Managers Claims field within the "Update Items" action.

 

I have made a test on my side, please consider modify your formula as below:

'PowerApp->Updateitem'.Run(
                           SharePointIntegration.SelectedListItemID,
                           Destination_DataCard1.Default,
                           Department_DataCard1.Default,
                           'Trip Start_DataCard1'.Default,
                           'Trip End_DataCard1'.Default,
                           'Estimated Cost_DataCard1'.Default,
                           'Trip type_DataCard1'.Default,
                            SharePointIntegration.Selected.Managers.Claims   // Modify formula here
)​​

Please take a try with above formula, then check if the issue is solved.

Note: The Managers_DataCard1.DisplayName formula would return the Display Name (e.g. "Managers") of the Managers field within your Edit form rather than selected value within the ComboBox.

 

In addition, based on the needs that you mentioned, I think it is not necessary to launch/fire a flow to update the current selected item. As an alternative solution, you could update the selected item within your custom form app directly.

Set the OnSelect property of the "Update Signature" button to following:

Office365Outlook.SendEmail(.....); // Type formula to send email
Patch(
       'Your SP List',
       SharePointIntegration.Selected,
       {
           ManagerSign: "Signed"
       }
)

or

Office365Outlook.SendEmail(.....); // Type formula to send email
UpdateIf(
       'Your SP List',
       ID = SharePointIntegration.SelectedListItemID,
       {
           ManagerSign: "Signed"
       }
)

 

Please take a try with above solution, check if the issue is fixed.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-xida-msft ,

 

The flow formula using the Selected Manager Claims instead of the DisplayName of the Manager worked as expected either the other formulas you mentioned to update the current item within the app directly.

Thank you very much for the clarification.

 

Regards,
Julien

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,345)