Answered

Datacard store the selected items from a combobox

(0) Share

Report

Posted on by Corleone

Hi everyone,

I have a SPL form (customize with Powerapps) which handle a list of request. For further explanation, we will call this SPL "Approval Request".

In parallel, I have a secondary SPL called "People" which give me a list of approvers.

In my main form "Approval Request", I added a connection to "People". Within this form I have inserted a combobox to select the people who has to approve my request. Take a look below:

How can I display the secondary data (email information) from the selected items into my second datacard "Emails of approver"? This datacard store the information in a column inside my database "Approval Request".

I used the formula below but is not working. Is driving me crazy! any idea? 😉 Thanks!!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

eka24 20,923 on at

Like (0)

Report

LookUp('Approval Request', People=Combobox.Selected.People, 'Email Information')

Or
LookUp('Approval Request', People=Combobox.Selected.Value, 'Email Information')
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Corleone 80 on at

Like (0)

Report

Hi,

I have tried both and is not working at all.

any other idea?

thanks a lot!!

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Kindly give the full code you use because am not sure of the column names. But the structure is correct
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Corleone 80 on at

Like (0)

Report

Hi @eka24 ,

yes of course! you are right. let me explain better.

let me show you first the two SPL structure:

My 2 datacards discussed: "To Send" & "Email of approver", the first one belong to my SPL "People", and the second belong to my main SPL "Request approval".

the formula used for Email of approver is: Default = LookUp('Approval Request',People=cbAprover.Selected.Value,Email)
fyi, here is the basic settings of my combobox:

hope this make sense. let me know if you need any other detail 😉 Thanks!!

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Try;
LookUp('Approval Request','Email of Approver'=cbAprover.Selected.Value,'Email of Approver')

Or
LookUp('Approval Request','Email of Approver'=cbAprover.Selected.Email,'Email of Approver')

Explanation; We are looking in the approval request List, look for email Column on the list which is equal to the email in the person list. If you find it, bring the email in the approval request list.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Corleone 80 on at

Like (0)

Report

Hi @eka24 ,

it does not work.
However, I was testing your formula and I tried in my datacard "Email of approver" to write the following: Default: cbAprover.Selected.Email. and it worked half the way:

what do you think?
Ideally what I need is something like: steve@outlook.com; adam@outlook.com; etc...

let me know what you think! 🙂

Was this reply helpful? Yes No
Verified answer

KrishnaV 5,023 on at

Like (2)

Report
Hi @Corleone ,

Try this:
Set the below formula onChange event of the people picker control in the form:
UpdateContext({varSelectedEmails:Concat(ForAll(DataCardValue182.SelectedItems,Email),Value&";")})
Now you set the variable back to a label/input text filed.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report

Hi @Corleone ,

Below is the working model of the solution:

Edit: Added Person filed Structure also
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
childishbambin1 6 on at

Like (0)

Report

is this one long string? varSelectedemail? what if i need logic to check for each email in this variable? can I do a foreach on this?

Was this reply helpful? Yes No