Answered

Item value on edit form

(0) Share

Report

Posted on by trandallvermont

I have a canvas app with a Form generated from a SharePoint List. I am trying to generate a link that can be sent in an email to come back and edit the form at a later point. I have populated the Item property on the Form on the edit screen with the following:

LookUp('List Name',ID=Value(Param("applID")))

The LookUp in the Item property is not working, even though it appears to recognize that it is a record.

record example.png

The parameter applID is passed in a URL linking to the edit screen.

<URL>?ScreenName=Edit&applID=7

The Lookup code above is not working when in the Item property on the form. However, it does pull the information if I replace the ThisItem. in the Default property on the Data Cards. Unfortunately, even if I populate the ID property from SharePoint by replacing ThisItem., it still creates a new record on submission.

Using ThisItem. will not populate data.

Using the Lookup will populate the information.

Any idea what I am doing wrong in my formula for the Item property on the form?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Item property should be record like LookUp('Accelerated Step Applications', ID=Value(Param("applId"))). Remove employee name or any string since item expects record through Lookup

Was this reply helpful? Yes No
trandallvermont 34 on at

Like
a
(0)

Report
Copy link

Link copied!

My screenshots probably muddied the water on this. This is the screenshot for the form properties. I do only have the lookup without any appended fields. I will update my original post to clarify.

Item property on form that is not working.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The lookup should work if the passing value is correct. Can you print/show on the label Param("applID") like below to make sure it's passing right id. I just verified again.

Was this reply helpful? Yes No
Verified answer

trandallvermont 34 on at

Like
a
(1)

Report
Copy link

Link copied!

I found the incorrect setting on the SharePoint form. I had copied the screen I was working on from another where the Default mode value had been set to New. Changing this to Edit resulted in the expected behavior.

Was this reply helpful? Yes No
trandallvermont 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your assistance on this and sorry it took so long to respond. I got pulled to a high priority project and am just now getting back to this.

Was this reply helpful? Yes No