You’re offline. This is a read only version of the page.
Announcements
Hi, I have a following SharePoint list with a lot of columns, and sometimes it looks like this:
I would like to load the last non-empty record as a default input for a text input field, so for 'motor cable size' it would be '1' (not blank).
Currently I use a code like this:
I know that I could rewrite the code and use !IsBlank for Cabling Cable size etc., but I have 100s of text inputs like this and I don't want to rewrite a code for all, it would be great to find a solution that I can find&replace. I tried Coalesce() but I don't know how to focus it on one column. Any ideas? Thank you
Hi @plona95
please try this forlmula I hope it helps you:
Share
Report
All responses (
Answers (
1,022
Coalesce(
LookUp(
Filter(
COLSavedDAM,
Site = CurrentSite,
'MCC Name' = CurrentMCC,
!IsBlank(CurrentMCC),
'Asset Name' = First(colAssetDetails).'Common Name',
!IsBlank('Starter Mains Power Cabling Cable Size')
),
true,
'Starter Mains Power Cabling Cable Size',
Descending
),
""
)The Coalesce() function returns the first non-blank value from a list of arguments.
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
Thanks!
