Unanswered

Patch one items access level, while patching all people manager items

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

I am trying to do a patch function within powerapps which allows me to delegate certain access levels to employees.

The image above shows the screen a manager would see. Basically what I am trying to do, is patch the headcount data source, and update the advisors access level based on what access level I have selected in dropdown2. However, as well as this, I want it to patch EVERY item in the table where I employees managers, and make the person I have selected all of their managers.

Example would be as follows:

I select steve in dropdown1 and I want him to be a manager role, the patch then updates steves access level to manager. Then the patch also updates every item in the table where I was the manager, and make the name in dropdown1 selected, the manager instead of me in the datasource.

Unsure if that makes sense but any help would be appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

You have to provide us with Table or List names, field names etc, before we can help. There isn't a way to really show you with out.

I do not know what Access means but is it a Choice column? Is that a drop down control or a combobox (I believe combox), can you select just 1 or more Delegations at time?

For patching all the records to make him their manager, we would need the field type and name (I am assuming its Person (SharePoint) or lookup (Dataverse) or other?

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to update the manager column as the dropdown1 selected user?

Could you please show me a sample about your data source?

Actually I am not sure if you have a standard Manager column where saving you as the manager, anyway, here is a solution I guess that you have a Manager column, and once you select Manager from the dropdown2, you will update the whol Manager column as dropdown1 selected user.

I assume you populate the Dropdown1 with office365users....

Set the patch button OnSelect as:

If(!IsBlank(ComboBox1.Selected.Email),UpdateIf(list,Manager.Email=User().Email,{Manager:ComboBox1.Selected}))

Also, to update the advisors access level based on what access level you have selected in dropdown2, you need to write the follwoing formula:

If(!IsBlank(ComboBox1.Selected.Email)&&!IsBlank(ComboBox2.Selected.Email),Patch(AccessLevel_list,LookUp(AccessLevel_list,UserColumn.Email=ComboBox1.Selected.Email),{AccessLvel:ComboBox2.Selected.Value}))

Here I assume that your accesslevel list has a person column to save the user name and a text type AccessLevel column to save the selected level.

Of course you could combine the above two formulas as below:

If(!IsBlank(ComboBox1.Selected.Email)&&!IsBlank(ComboBox2.Selected.Email), UpdateIf(list,Manager.Email=User().Email,{Manager:ComboBox1.Selected})&&Patch(AccessLevel_list,LookUp(AccessLevel_list,UserColumn.Email=ComboBox1.Selected.Email),{AccessLvel:ComboBox2.Selected.Value}))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi there,

yes sorry, the data source is coming from an sql database. Whereby each row is a new "Advisor" and within that row there is a manager column, as well as what access level they have. see below, thank you

Was this reply helpful? Yes No