Getting ID from a variable to add data to a SharePoint list

(0) Share

Report

Posted on by pdeubner

Dear,

I am currently struggling with the following scenario.

A form (based on a SharePoint online list is split over two screens. I want use a variable to identify the the SharePoint list items that needs to be altered (i.e. added information) on the second screen.

Unfortunately, I am struggling here - and would appreciate some more guidance, as the information I found here does not get me further.

What I have is:

On Screen 1:

Submission button:

 Set(varIndexfolge;Max('CHX-Kalkulationsanforderungen';Indexfolge)+1);;
SubmitForm(Form1)

onSuccess:

Set(varCreationID;Self.LastSubmit.ID);;
 Patch(
 'CHX-Kalkulationsanforderungen';
 {ID: Self.LastSubmit.ID};
 {'PM fertig': true}
);;
If(Self.LastSubmit.'sofortige SAP-Anlage';
Navigate(PM_DefinitionScreen_immediate_Creation;ScreenTransition.Fade);Navigate(End_Success;ScreenTransition.Fade));;
ResetForm(Form1)

on Screen2:

DefaultMode:

FormMode.Edit

Item:

Filter('CHX-Kalkulationsanforderungen';ID=varCreationID)

What I expected is that I would be able to amend the information that was entered on Screen1 on Screen2.

But I see an error stating that a "record value is expected".

This corresponds to the variables definition screen

What am I missing here?

Thank you for your support,

regards

Philip

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @pdeubner ,

You just need LookUp (you need a record, not a Table) as the Item of the second Form

LookUp( 'CHX-Kalkulationsanforderungen'; ID = varCreationID )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
pdeubner 24 on at

Like (0)

Report

That‘s it - thank you.
So just to summarize - when I know that the result will be always only one, it is LookUp(), otherwise Filter(), right?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @pdeubner ,

LookUp returns a Record (actually the first matching item it finds) and a Form requires a single Record. Filter returns a Table of all matching records for controls like Galleries and Dropdown/Check Boxes.

Was this reply helpful? Yes No