Unanswered

Pre-populate Fields based on value and allowing users to edit it

(0) Share

Report

Posted on by HiddenPants

Hello everyone,

I have an powerapp that lets users complete their onboarding process. I have set up my list and forms in the app and used the Patch function to collate the responses from different screens/forms. However, I want to give users the opportunity to be able to edit their information if they please.

Current situation:

When a user inputs the Student ID and select the Peer Program, a new record is created.

The Problem:

Users cannot edit their information. For example, if they have not finished step 2 yet, they can come back at a later date and just update that.

Ideal Solution:

Users will be able to input their Student ID and Peer Program then these will be checked in the list:

If a record with the same Student ID AND Peer Program is found, then that record is loaded on the following screen (that has the steps) and the answers associated with it as well.
If a record with the same Student ID and Peer Program IS NOT found, then a new record will be created and users will be able to complete the form as expected.

Hope this is clear but happy to explain more.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @HiddenPants ,

When you've said you've used Patch it's custom implementation.
In screen 1 when Student Enters StudentID & Peer Program and clicks on Next
Perform lookup on for above two field criteria.
If result is not blank save the result(single list item) in context variable
use same ctx variable you can map the default values of the controls
When student fills in the form and submits finally you can again call patch function with ID to update or if not call patch with defaults to create a new ones.
Patch to create new :
Patch(SPList, Defaults(SPList), {Status: {Value:"ABC"}} )
Patch to update existing record
Patch(List, Lookup(List, ID= ctxItem.ID), {Status: {Value:"ABC"}} )

Thanks
Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
HiddenPants 6 on at

Like (0)

Report
Copy link

Link copied!

Hello, thanks for your response.

I'm wondering if I need to add an if function to check if the result is not blank? Would they all be code on the same button?

I'm also wondering how to code storing the ctx variable?

I'm new to PowerApps sorry!

Was this reply helpful? Yes No