Unanswered

power app form

(0) Share

Report

Posted on by SL-07111355-0

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)

All responses (9)

Answers (0)

WarrenBelz 148,684 Most Valuable Professional on at

Like (0)

Report

Re: power app form

@swelihle ,

On the original
SL-07111355-0 on at

Like (0)

Report

Re: power app form

WHERE ?
WarrenBelz 148,684 Most Valuable Professional on at

Like (0)

Report

Re: power app form

@swelihle ,

Please see amended post
SL-07111355-0 on at

Like (0)

Report

Re: power app form

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 148,684 Most Valuable Professional on at

Like (0)

Report

Re: power app form

@swelihle ,

Glad you have solved it - I was somewhat unclear what you were doing
SL-07111355-0 on at

Like (0)

Report

Re: power app form

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 148,684 Most Valuable Professional on at

Like (0)

Report

Re: power app form

@swelihle

What exactly is previousSubmission - you are setting it as a Variable
SL-07111355-0 on at

Like (0)

Report

Re: power app form

I'm getting invalid argument type: expected table value instead on these lines - Last(previousSubmission)
WarrenBelz 148,684 Most Valuable Professional on at

Like (0)

Report
Re: power app form

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