Unanswered

Using two edit forms in PowerApps to add/edit records to a single SharePoint list has two bugs

(1) Share

Report

Posted on by musiconpiano101

Hi,

I'm experiencing two issues in PowerApps (PA) with a screen that has two edit forms linked to a single SharePoint (SP) list:

All Field values in Business Form (top form) are saving correctly when creating a new or editing an existing record and the drop-down values are correct. All Good
Issues are in the Admin Form:
1. Published PA to SP and when opening a new or selecting an existing record via SP List View, the drop-down field values are displaying "Item 1, Item 2, etc." instead of the correct values. (the drop-down values are in other SP Lists using Lookup field) The drop-down values do appear correctly when testing with Play button in PA
2. Text Field values are also not saving to the SP List

Screen Layout:

The App

I've built the App using a long single PowerApps (PA) screen (FormScreen1) from a single SP List (New Demand Requests) with two edit forms
The two edit forms are BusinessForm & AdminForm and both are using the same SP List as the Data Source
The BusinessForm is on top and AdminForm is below it
To add a new record, user will be creating a new SP record from the basic SharePoint list view and selecting the "+ New" button
To modify an existing record, user will be selecting an existing record from basic SharePoint list view
Fyi, I'm not using a Gallery to select records from

Basic screen design is:

The columns on both forms are in Display Mode = Edit
I have not created Display Modes for the View or Disabled Modes
Detecting New vs. Existing Record Using `Param("ID")
- I've learned SP handles redirection to PA when user clicks "New" button or when selecting an existing item it passes the Item ID using (Param("ID")
Item Property Settings:
- BusinessForm =
  If(IsBlank(SharePointIntegration.Selected),First([@'New Demand Requests']),
  SharePointIntegration.Selected)

AdminForm =

If(IsBlank(Param("ID")),
Defaults([@'New Demand Requests']), // For new records
LookUp([@'New Demand Requests'], ID = Value(Param("ID"))) // For existing records
)

Set the Form Mode on both forms
If(
IsBlank(Param("ID")),
FormMode.New, // New record mode
FormMode.Edit // Edit mode for existing records )
Set the "Submit" Mode on both forms
SubmitForm(BusinessForm);
SubmitForm(AdminForm)
Need a Solution:
From what I've read online, I believe I need to use a variable somewhere but don't know what to do to resolve the two bug issues.

Categories:

Building Power Apps

Demand.png

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,325 Super User 2025 Season 2 on at

Like (0)

Report

Hi

So firstly, you are mixing what you need to do.

If I understand correctly they both use the same Datasource, which means (to me) that you either have 2 records, 1 of business and 1 of admin, or you have 1 record, where some fields are part of Admin and some are party of Business.

If its the later, then your first big issue is you are creating a new record for EACH form when its a new.

Instead you should create a New one with the Business, making them save that first, so you can get the ID, and use that in a Lookup in the Admin form.

Can you clarify the pattern please (one line, or 2 items)

Was this reply helpful? Yes No
musiconpiano101 13 on at

Like (0)

Report
Hi FLMike

Thank you for your quick response.

I'm using one SP record, where some fields are part display on the Admin section and some display Business section

The design was to use just the FormScreen1 with two "edit form" controls added to it. Business on Top and Admin on the bottom

One SP record is created by Business User and Admin User modifies existing record info on bottom section

The business process goes:

Business User clicks on "+ New" and fills in the top section only and Submits the form and new record gets added to list

Once the new record is added to the list, an admin user will open it directly from the List View and fills in data on the bottom "Admin" bottom section and clicks Submit button

The Submit buttons (2) have:

SubmitForm(BusinessForm);

SubmitForm(AdminForm)

5. Admin continues to edit the record until it is transferred elsewhere

6. If Business needs to modify record, they select it from List View, click on "Edit" on top menu and "Submit" the form

when they are done

What I didn't have time for initially was to use two Tabs with one SP Record and the same process below however the Admin User won't need to scroll

all the way down to modify their data, just click on the Admin tab... If this 2nd solution is ultimately easier please indicate.

Thank You

Was this reply helpful? Yes No
musiconpiano101 13 on at

Like (0)

Report

Hi

It is the latter, I'm creating one SP List record where some fields are part of Admin and some fields are part of Business

Regards,

Stephen

Was this reply helpful? Yes No
musiconpiano101 13 on at

Like (0)

Report

I'm using just 1 SharePoint List

I will change design to use two SharePoint Lists, one of Business Submission and one for Admin

Stay tuned...

Was this reply helpful? Yes No