OnSelect-multiple functions on button

(2) Share

Report

Posted on by joel914823

557

I have a button where when it is clicked - it updates the "Assigned To" to the person that is signed in.

I'd like to add two more functions to the same button:

1. Could it update the "Status" Field (which is a choice column) to "In Progress"

2. Could it Auto-Save the record or push to save somehow?

Any help on those two items will help. thank you.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

cfoenki 100 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi joel914823,

I assume that you put on the DefaultSelectedItems of the field AssignedTo something like if(var_Assign=true,User(),Blank())?

Then on the Status you should do something similar: if(var_Assign=true,{Value: "In Progress"},Blank())

To help you with the save we need to now what is the datasource where you want to save your info.
joel914823 557 on at

Like
a
(0)

Report
Copy link

Link copied!

@cfoenki Thank you so much! That worked....

To save - the datasource is a Sharepoint list - and the list name is "Service Recovery Group"
cfoenki 100 on at

Like
a
(1)

Report
Copy link

Link copied!
Glad the first part worked.

Then you should Patch your record when the button is clicked.

If it is a new record then just patch your SP datasource datasource:

Patch('Service Recovery Group', Defaults('Service Recovery Group'), {'Assigned To': { '@odata.type': "Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & User().Email), Department: "", DisplayName: "", Email: "", JobTitle: ".", Picture: "." }, Status: {Value: "In Progress"} } )

This code only works if you have a column called "Assigned To" of type Person/Group and a column called "Status" with type Choice.

Otherwise, just adapt.

I supposed that you only click once on the button Auto-Assign and afterwards the button is greyed out
joel914823 557 on at

Like
a
(0)

Report
Copy link

Link copied!

@cfoenki Thanks again - I must be doing something wrong as I inputted below but seems to error out.

Yes if there is a way to grey out the button that would be fantastic, how could I do that?
cfoenki 100 on at

Like
a
(0)

Report
Copy link

Link copied!
My bad, just remove the bracket, I made a mistake when adapting my code:

Patch('Service Recovery Group', Defaults('Service Recovery Group'), {'Assigned To': { '@odata.type': "Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & User().Email, Department: "", DisplayName: "", Email: "", JobTitle: ".", Picture: "." }, Status: {Value: "In Progress"} } )
joel914823 557 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @cfoenki you are awesome!

To grey out the button after use....how could I do that - or does the below automatically do it? Thank you.