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

I have the same question (0)

All responses (6)

Answers (0)

cfoenki 100 on at

Like (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.

Was this reply helpful? Yes No
joel914823 557 on at

Like (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"

Was this reply helpful? Yes No
cfoenki 100 on at

Like (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

Was this reply helpful? Yes No
joel914823 557 on at

Like (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?

Was this reply helpful? Yes No
cfoenki 100 on at

Like (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"} } )

Was this reply helpful? Yes No
joel914823 557 on at

Like (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.

Was this reply helpful? Yes No