Power Platform Community Forum Thread Details

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:

Spoiler (Highlight to read)

If(
!IsBlank(First(Filter(COLSavedDAM, Site = CurrentSite, 'MCC Name' = CurrentMCC,!IsBlank( CurrentMCC), 'Asset Name' = First(colAssetDetails).'Common Name' )).'Starter Mains Power Cabling Cable Size'),
First(Filter(COLSavedDAM , Site = CurrentSite, 'MCC Name' = CurrentMCC,!IsBlank( CurrentMCC), 'Asset Name' = First(colAssetDetails).'Common Name' )).'Starter Mains Power Cabling Cable Size'
,
"")

If(!IsBlank(First(Filter(COLSavedDAM, Site = CurrentSite, 'MCC Name' = CurrentMCC,!IsBlank( CurrentMCC), 'Asset Name' = First(colAssetDetails).'Common Name' )).'Starter Mains Power Cabling Cable Size'),First(Filter(COLSavedDAM , Site = CurrentSite, 'MCC Name' = CurrentMCC,!IsBlank( CurrentMCC), 'Asset Name' = First(colAssetDetails).'Common Name' )).'Starter Mains Power Cabling Cable Size',"")

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

Categories:

Building Power Apps