Power Drag and Drop

(1) Share

Report

Posted on by jsmith87

297

Hi all,

I have been working on Scott Durrow's power drag and drop and have encountered an issue, I keep getting the below error, any ideas? I have tried to add as much info below to help.

ForAll(Filter(Unassigned.CurrentItems,HasMovedZone=true) As TaskAssignment,
// Update local collection with new person/date
Patch(ColTaskstwo,
LookUp(ColTaskstwo,Text('JobDetails') = TaskAssignment.ItemId),
With(
    {
        StartDate:varSelectDateDay,
    ZoneData:Split(TaskAssignment.DropZoneId,"|"),
    Unassigned: TaskAssignment.DropZoneId="Unassigned"
    },
    {
        Zone:TaskAssignment.DropZoneId,
        //Get Assigned To
        'Assigned To':
        If(Unassigned,
        Blank(),
        LookUp(colPeople,cre3f_engineernamesid =
        GUID(Last(ZoneData).Value)))
 
Youtube link - 7m 33s into the video
https://www.youtube.com/watch?v=wkHvjusgLEE&list=PLhgOm-Jpmt82JvLdJFx3Zqo89h_deWJQF&index=3&t=587s
 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Pablo Roldan 316 on at

Like (0)

Report
Copy link

Link copied!

I'm not familiar with this table is that a custom table or an activity table in Dataverse? but take a look at that field cre3f_assignedto that clearly is a custom column/field and it's configured to be of type Text/String, it should be of type LookUp to target systemuser Table... Double check at you table schema you may need to drop that column and create it with the specified type.

regards,

Was this reply helpful? Yes No
Jeffer Ni 10 on at

Like (0)

Report
Copy link

Link copied!
Hello,

The LookUp function returns a Record type data, which does not match the expected data type Text for the Assigned To column. Please restrict the output to a specifc column within colPeople collection:

LookUp(colPeople,cre3f_engineernamesid = GUID(Last(ZoneData).Value)).'Assigned To'

BR,

Jeffer Ni

Was this reply helpful? Yes No