power app form

[swelihle]

hey guy can u kindly assist me here I'm try to build PowerApps form that submit data to SharePoint once the data is submitted it must return last submitted data from the list on the form again if the user is trying to submit another set of data 

my table  these  fields , want the data to be returned to form if total road length <> End Point / km  and assigning the end point /km , date must be blank and end point must be blank as well for the second submission , all the other field must be populated by last submitted  data on the list, I've tried using 

Set(
previous Submission,
If(
previousSubmission.'TOTAL ROAD LENGTH' <> previousSubmission.'END POINT/KM',
LookUp('Internal Blading List', 'ROAD NUMBER' = previousSubmission.'ROAD NUMBER'),
Blank()
)
)

 on visible property of my screen but it doesnt return my data even if i set all my default fields to previousSubmission for example i on road number i would set default property to previousSubmissiom.Road Number  

Date

Description of work being done

Road Number

Total Road Length

Start Point/ km

End Point/ km

Unit of Measure

Output achieved

Vehicle/Plant Registration

Hours Worked (if applicable)

Fuel

Comments                                                                                                            (In particular to Variance, Corrective Action, Quality and any other pertinent information)

[WarrenBelz]

Hi @swelihle ,

I am not totally clear here, but if you want to return the values from the last submitted record

Set(
   previous Submission,
   If(
      Last('Internal Blading List').'TOTAL ROAD LENGTH' <> Last('Internal Blading List').'END POINT/KM',
      Last('Internal Blading List').'ROAD NUMBER',
      Blank()
   )
)

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[swelihle]

I'm getting invalid argument type: expected table value instead on these lines - Last(previousSubmission)

[WarrenBelz]

@swelihle 

What exactly is previousSubmission  - you are setting it as a Variable

[swelihle]

I've found this solution 

onVisible of my screen 

If(

  previousSubmission.'TOTAL ROAD LENGTH' <> Round(previousSubmission.'END POINT/KM', 3),

  Set(

    previousSubmission,

    Last(Filter('Internal Blading List', 'ROAD NUMBER' = Trim(DataCardValue45.Text)))

  ),

  Notify("ROAD IS COMPLETED"),

  Blank() ,

  previousSubmission is a variable that stores data that was previously last submitted , but my challenge here is that even if previousSubmission.'TOTAL ROAD LENGTH' = Round(previousSubmission.'END POINT/KM', 3) , the value from the list are return , instead of displaying road is completed and reset the form for new submission for the next road 

[WarrenBelz]

@swelihle ,

Glad you have solved it - I was somewhat unclear what you were doing

[swelihle]

WELL IM DEVELOPING A FORM WHERE USER SUBMIT THE INFORMATION ON MY TABLE , MY USER IS WORKING ON SOME SORT OF ROAD TASK, SO SOMETIMES I CAN TAKE MORE THAN A DAY TO WORK TO COMPLETE TASK , WHAT IM TRYING TO ACHIEVE HERE , I WANT TO ENABLE USER TO HAVE PREVIOUS DATA STORE BY DEFAULT FOR THE SECOND SUBMISSION , END POINT OF PREVIOUS SUBMITED MUST BE STORE ON THE START POINT FORM NEW SUBMISSION SINCE THEY BE CONTENIUNG WHERE THEY LEFT OF AND THE DATE AND END POINT MUST BE LEFT BLANK SO THAT THE USER WILL ENTER THE DATE AND END POINT FOR THE SECOND DAY SUBMISSION 

[WarrenBelz]

@swelihle ,

Please see amended post

[swelihle]

WHERE ?

[WarrenBelz]

@swelihle ,

On the original