cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raeville
Frequent Visitor

Auto populate form fields from another SharePoint list

 

I created a SharePoint list with two columns - Role (Title) and Person 

 

Role     Person

CIO      Person A

CFO     Person B

CEO     Person C

 

In my PowerApps Form (separate SP list), I would like to populate three fields with the Person above. 

 

Example: 

 

I want to populate the following fields when the form is open :

 

  1. "IT Approval" with Person A
  2. "Finance Approval" with Person B
  3. "Management Approval" with Person C

 

All the fields above are Person field in both SharePoint lists. 

 

How do I set it up so that the above form fields are auto-populated when the form loads. 

 

Thanks. 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Raeville

 

Set the defaults property of "IT Approval" to

 

Lookup(SharepointListwithCIOCFOCEOnames, Role="CIO",Person)

 

and similarly for the other roles.

 

Hope this helps!


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3

@Raeville

 

Set the defaults property of "IT Approval" to

 

Lookup(SharepointListwithCIOCFOCEOnames, Role="CIO",Person)

 

and similarly for the other roles.

 

Hope this helps!


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

HI @ThatAPIGuy

 

When i put the formula in the default property, it worked a treat. However, doing that meana i'm defaulting the data card value to the Lookup value. It is good when i open up a new form, but it will still show up as the default value when i open in edit/view mode. The SharePoint list item will show the correct value, but when clicked into PowerApps, it shows the default value. 

 

I'm doing this on a customised form. 

 

Do you know how i can overcome the value discrepancies?

 

Thanks again. 

Create a ContextVariable on your Button Select for New and Edit e.g.

 

UpdateContext({CustomForm:"New"})
UpdateContext({CustomForm:"Edit"})

 

Then use an If Statement in the Default Propery e.g.

 

If (CustomForm = "New", Lookup....., Blank())

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (18,675)