Answered

ForAll issue

(0) Share

Report

Posted on by NM-06090901-0

152

ForAll(CollLang,
    If(IsBlank(ThisRecord.ID),
    Patch('Languages spoken',Defaults('Languages spoken'),{Language:ThisRecord.Language,'Language Proficiency':ThisRecord.'Language Proficiency','Social Insurance Number':varsocial}), 
    Patch('Languages spoken',{Language:ThisRecord.Language,'Language Proficiency':ThisRecord.'Language Proficiency','Social Insurance Number':varsocial})))
 
 
I have above formula that takes  the collection i made from a condition .The logic is to update already existing records if they are old and create new records if they are new.For some reason it always creates new records.I can see in my collection that new records indeed have a blank ID but still a new record is created
 
Can someone assist please? 

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

mmbr1606 13,039 Super User 2025 Season 1 on at

Like (0)

Report
ForAll issue

hey

thanks for the update:

ForAll( CollLang As Lang, If( IsBlank(Lang.ID), // Create new Patch( 'Languages spoken', Defaults('Languages spoken'), { Language: Lang.Language, 'Language Proficiency': Lang.'Language Proficiency', 'Social Insurance Number': varsocial } ), // Update existing Patch( 'Languages spoken', LookUp('Languages spoken', ID = Lang.ID), { Language: Lang.Language, 'Language Proficiency': Lang.'Language Proficiency', 'Social Insurance Number': varsocial } ) ) )

If your "Language spoken" tables ID column is a GUID rather than a number, ensure to use GUID( ) in the lookup filter or cast the types appropriately.

If my answer was helpful and solved your issue, please mark it as the verified answer.

If it helped but didn’t fully solve it, I’d appreciate a like. 😊

And if you’d like to support me, feel free to buy me a coffee.
NM-06090901-0 152 on at

Like (0)

Report
ForAll issue

Hi @mmbr1606

Adding the lookup gave me a 400 error

Error when trying to retrieve data from the network: Fetching items failed. Possible invalid string in filter query

After using the below i got it resolved with the (As)

ForAll( CollLang As Lang, If( IsBlank(Lang.ID), // Create new Patch( 'Languages spoken', Defaults('Languages spoken'), { Language: Lang.Language, 'Language Proficiency': Lang.'Language Proficiency', 'Social Insurance Number': varsocial } ), // Update existing Patch( 'Languages spoken', LookUp('Languages spoken', ID = Lang.ID), { Language: Lang.Language, 'Language Proficiency': Lang.'Language Proficiency', 'Social Insurance Number': varsocial } ) ) )
mmbr1606 13,039 Super User 2025 Season 1 on at

Like (0)

Report
ForAll issue

hey

can u try this:

ForAll( CollLang, If( IsBlank(ThisRecord.ID), // Create new Patch( 'Languages spoken', Defaults('Languages spoken'), { Language: ThisRecord.Language, 'Language Proficiency': ThisRecord.'Language Proficiency', 'Social Insurance Number': varsocial } ), // Update existing Patch( 'Languages spoken', LookUp('Languages spoken', ID = ThisRecord.ID), { Language: ThisRecord.Language, 'Language Proficiency': ThisRecord.'Language Proficiency', 'Social Insurance Number': varsocial } ) ) )