link between two forms at same SP list

(0) Share

Report

Posted on by dina-yasser

Hi there , actually i'm having a sharepoint list with several columns

i created my first app with specific fields (not all fields of my list ) then submitted it

in my second app i retrived the previous submitted data with the id

then created seconed form with the rest of the data

so i want to fill the data and update this record with my new data

how to do this

and another problem that when i start inserting in second form the data viewed in first form is disappeared .

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dina-yasser ,

In canvas, form have three modes: ‘New’, ‘Edit’, ‘View’.If you want to modify a record instead of creating a new one, I suggest using Edit mode.

Create a list with title and three text columns.

The form in the first app fills in the title and A_Info to create a new record, so here the form mode is New.

Fill in the data and submit.

The form in the second app is used to update data, so the mode need to be edit

Edit mode to select records, so need to use LookUp() to filter the ID of the record you want to update

The data is entered and submitted, and the record is modified in the data source.

On another question, I suggest you check the properties of the submit button to see if the first form is reset on submission. The specific reason may require you to provide more information.

Best Regards,

Wearsky

Was this reply helpful? Yes No
amirmohamed 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft
Thanks for you answer

If I need to read to a field instead of LookUp('talb sarf step 1',ID=1) , a static "1"
I tried the below
LookUp('talb sarf step 1',ID= Title_DataCard2)

Was this reply helpful? Yes No
dina-yasser 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response.

But how if i need to do that when my 2nd field (Title) = my 1st field
when this condition is true i want to edit this record not by adding a static ID value

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dina-yasser ,

Hope you are doing well.

If you have two apps and want the second app to modify the data entered by the first app, you can use Launch() and Param().

I made a model for you:

Add a form to the first app and mode is 'new'.

The submit button is set to the following formula.

SubmitForm(Form1);Launch("YOUR-APP-WEBLINK &source=portal",{PaA:Form1.LastSubmit.Title},LaunchTarget.New)

Launch() is the web link to the second app, which can be viewed in Apps-Details

When using it, you need to add '&source=portal' at the end of the link.

The outgoing parameter 'PaA' here is the title of the last data stored in the form.

In the second app, add a form with mode is 'edit', and the Item is set to the following formula:

Enter the data in the first app, click submit, and will be redirected to the second app.

The second app displays the rows of data entered in the first app.

Best Regards,

Wearsky

Was this reply helpful? Yes No