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) |
