Unanswered

Auto populate text field in editable grid

(0) Share

Report

Posted on by ReveredBeard

Hi all,

I am trying to have a text field auto fill on an editable grid as shown in Reza Dorrani's video ((556) Editable Grid in Power Apps | SharePoint List - YouTube).

I would like the 'Check completed by' field to auto-fill User().FullName OnSelect of the 'latest check' field.

All I have managed to do is get the whole column to update.

Any help would be greatl

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report
Hi @ReveredBeard ,
If you are using a label control, you can use below formula in Text property of it -

If(!IsBlank(latestCheckDataPicker.SelectedDate) && !IsBlank(ThisItem.'Check completed by'), User().FullName, ThisItem.'Check completed by')

Was this reply helpful? Yes No
ReveredBeard 62 on at

Like (0)

Report

Hi @NandiniBhagya20 ,
Thank you for you comment however all this did was change any prefilled fields to my name. I need the previous ones to remain the same and when i amend the next row down's date that the 'check completed by' then inputs my name in that specific row.

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report
Hi @ReveredBeard ,
Try using below formula -

If(IsBlank(ThisItem.'Receiving Officer'), User().FullName, ThisItem.'Receiving Officer')

Was this reply helpful? Yes No
ReveredBeard 62 on at

Like (0)

Report

Hi @NandiniBhagya20 ,
Unfortunately that just prefilled all the blank fields.

Was this reply helpful? Yes No
Verified answer

ReveredBeard 62 on at

Like (0)

Report

Combined the If functions:

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Hi @ReveredBeard ,
The below formula will fill the label with user's name when Date is not blank -

If(!IsBlank(ThisItem.'Receiving Officer'),ThisItem.'Receiving Officer', If(IsBlank(LatestCheck.SelectedDate),ThisItem.'Receiving Officer', User().FullName))

Was this reply helpful? Yes No