Autopopulate datacard in form with an ID from a different form

(0) Share

Report

Posted on by Lennova

Hi,

I am trying to autopopulate a datacard with an ID from a different form.

The ID from form frmTaskSchedule (datasource: sharepoint list 'Task' should be populated in frmNewComment (datasource: sharepoint list 'Task Comments'). The 'Task Comments' list has a lookup column with the ID from the 'Task' list.

That lookup columns needs to be populated when submitting the form.

At the moment I am only getting a blank in that column when submitting the form.

I have a variable 'newID' to load data in the frmTaskSchedule and wanted to use the same for populating the datacard.

It is giving me a 'Expected Record value' when I use the 'newID' in the Default for the datacard.

Any suggestions?

Regards,

Hans

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lennova

You will need to use Lookup() to identify the record for the form in another data source. So if the data source is SPlist, then the Item property of the form will need to be Lookup(SPlist, ID=newID). The Item must match the data source.
Lennova 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp ,
Thanks for your reply. That is the issue I am having with the item must match the data source.

I have a form where a user can put in a request (to SPlist 'Task'). A different department will then put timings against the request in an edit form (again to SPlist 'Task'). Users should then be able to add comments to the request and those comments are added to a SPlist 'Task Comments' which contains a lookup column to the 'Task' SPlist.

When a user wants to add a new comment they click a button where a form becomes visible with the source 'Task Comments'. When submitting the form I want to have the ID of the 'Task' to be added to the lookup column in 'Task Comments'.
Lennova 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Does anyone have any ideas what i can do?

In the worst case i could do it without using the lookup column in the sharepoint list thus breaking the link between task and comment...