Answered

AutoPopulate all fields on the form when dropdown value changes

(0) Share

Report

Posted on by Snacham

Hi,

I have a SP list Social which contains SocialMedia dropdown and some text fields. I need to auto populate all the fields from the list when my dropdown value changes on my powerapps form.

Fields from my powerapps form -

Dropdown- SocialMediaddl field which has values from SP list SocialMedia dropdown, Textbox -Net working Media

Approach -

SocialMediaddl onchange - I am resetting the 'Net working media' value

Net working Media on Default - LookUp(Social, SocialMedia = SocialMediaddl.Selected.Value, 'Net working Media')

But i am receiving an error in the LookUp formula at '=' symbol that says Invalid argument type. Attaching the screenshot for the reference.

Please correct me.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please can you show the code on the Combobox?

Try this;

LookUp(Social, SocialMedia in SocialMediaddl.Selected.Value, 'Net working Media')

------------

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
Snacham 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for responding quickly. Attached the code on the dropdown field for Items and OnChange.

And also I changed the code on my textbox as you mentioned above, but I see error at Value and attached the error.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi

Please i asked for the Code on the Items property of the Combobox.

Kindly show that.

------------

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
Snacham 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Here is the screenshot for the items property of combo box.

Thanks,

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Consider this:

LookUp(Social, SocialMedia.Value = SocialMediaddl.Selected.Value, 'Net working Media')

------------

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
Snacham 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @eka24 . It worked!!

Was this reply helpful? Yes No