Answered

Set Default Datacard to present previous Record

(0) Share

Report

Posted on by cesarllebron

Hi,

I'm trying to set-up in a datacard named Shift, Work Hours ect, the default to be the last record saved. By the time the person press new record, the datacards will be populated with the last saved records.

The intention is to reduce the amount of entry that a person will conduct during the form data entry.

Please any help on this,

Cesar L. Lebron

OEE APP Example.docx

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Kimii 134 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @cesarllebron
You can get last record data with Last function.
please check this link below:
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-first-last
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cesarllebron ,

Am I right in thinking you want to auto-populate some of the forms based on the last submission? If so use the LastSubmit function:

FormName.LastSubmit.ColumnName

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218
cesarllebron 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Good Morning

I tried the formula, unfortunately did not work. Once I reset the form to document new records, the information as example working hours did not showed the last record.

Attached the print screen with the steps I followed.

Just to mention the datacards are the following:

1. Date - Date selection
2. Shift - is Choice
3. Style - Is Choise
4. Molding Tool - Is Choise
5. Work Hours - Manual entry data
6. Production - Manual entry data
7. Cavities - Manual entry data
8. Machine Cycle - Manual entry data
9. Employee Number- Manual entry data

Any thoughs?

OEE Formula Resul...
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

On the save when it submits can you try calling a refresh to the datasource ?
cesarllebron 56 on at

Like
a
(0)

Report
Copy link

Link copied!

How I do that?, In the save button commands?
Verified answer

Kimii 134 on at

Like
a
(0)

Report
Copy link

Link copied!

@cesarllebron
1. Date - Date selection
[DefaultDate] property: Last(YourList).Date
2. Shift - is Choice
[DefaultSelecteditems] property: Last(YourList).Shift
5. Work Hours - Manual entry data
[Default] : last(YourList).WorkHours
then same way with other cards

Hope it helps,
cesarllebron 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Greetings Phipps0218

How Can I do that?
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Refresh(datasourceName);
cesarllebron 56 on at

Like
a
(1)

Report
Copy link

Link copied!

Greetings

Thanks for the help, It did work, however I have to use the First instead of last, because the return value was the first in the data table. Once I changed to First, It returned the last record saved.