cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

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

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (13,118)