Manage datacardvalue for multiple persons

(0) Share

Report

Posted on by jero_piz

Hi,

I am quite new with PowerApps and I hope PowerApps community can help me!

I use two Sharepoint Lists

1) Request : which aims at managing travel requests and where an applicant can add location, dates, manager, ... In that list you have notably columns applicantN, managerN

2) Applicant : where all persons and their direct manager is indicated (column 1 : applicantName and column 2 : managerName)

I want to autopulate the manager DefaultSelectedValue of the Manager Combo box corresponding to the different applicantName selected (you can select several applicants). For example when you choose applicants A and B you have managerA and managerB selected automatically in the combobox.

I finally manage to perform it with the following code in the applicantN combobox (DataCardValue2) of the sharepoint form with the following code (where managerList is created on New Form)

Set(ManagerEmail;LookUp(Applicant;applicantName.Email=DataCardValue2.Selected.Email;managerName));;
Patch(managerList;Defaults(managerList);ManagerEmail)

In that case it works well when you add several applicants, but when you remove one it does not remove the corresponding manager. For example if I have applicants A and B and I remove applicant B, I only want to have applicantManager A in the managerN combobox.

Can you help me resolving this issue? I think I have this problem because I was not able to select all applicants (I thought that SelectedItems would have resolve this issue but I was not able to use it properly).

Many thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jero_piz ,

Try this - on the OnChange of the ComboBox

Clear(managerList);; ForAll( Self.SelectedItems; Collect( managerList; {ManagerEmail: Value} ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
jero_piz 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Tanks for your quick answer.

Unfortunately it does not work.
First I replaced "Value" in your code because I had some errors and I used different solutions without a success.
What is strange is when I add an user in the combobox it adds me a new line the Collection managerList but when I add another one, a new row is created but with twice the information of the last user. This is as this code only uses information of the last person I selected.
Any other idea ?

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jero_piz ,

Two things -

What are the Items of your ComboBox? The reason you need to replace Value lies here. Either a Choice or a Lookup field needs Value. One based on a list needs the actual field name displayed.

Secondly, did you put the Clear(CollectionName) at the top. I have actually tested this code on a model and it works exactly as expected. The code does not use the last one selected - it replaces what was there before with all selected items.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
jero_piz 6 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you.
It partially solved my issue. I managed it with 2 lists :
1) one to get record from applicants
2) the other to compare these persons to my second sharepoint list

I was able to display these names in the managerN combo box thanks to
DefaultSelectedItems = managerList.DisplayName
But I was not able to save them in my Sharepoint list (because it is just a DisplayName and not a full person record).
How to display these multiple managerName and save them in Sharepoint?

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @jero_piz ,

I responded to the question you asked (I hope this solved it), but I do not use person fields (or any complex field types if SharePoint is my Power Apps data source), however here is a good thread on the subject.

This video from Shane Young may be work a look regarding the issues.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BrandonBenitez 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Y si quiero contar el total de opciones que seleccióno en mi DataCardValue como almacéno ese dato y como lo paso a otro DataCardValue de tipo número

Was this reply helpful? Yes No