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 :
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.
Solved! Go to Solution.
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.
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.
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())
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
37 |
User | Count |
---|---|
294 | |
248 | |
123 | |
74 | |
55 |