SharePoint Update Item - Split Function

[RitabPedrosa]

Hi!!
Need some help 🙂

I have a SharePoint Table [Image 01] and I want to update the last 2 columns with 26/12/2020 and 31 (example)

I made a test with Compose + Split Function and the result was exacty what I need [Image 02]

       DataPresenca: Split(outputs('Compor_-_Teste_Data-IDLoja'),'-')[0]  -----> 26/12/2020
       ID_LojaPresenca: Split(outputs('Compor_-_Teste_Data-IDLoja'),'-')[1] ------> 31

But I cant find the formula that update the information on SharePoint - Its always giving an error on the expression (split function is not valid)

    Slplit(items('Aplicar_a_cada')?['ID_LojaPresenca'],'-')[1]

[tom_riha · Accepted solution]

Hello @RitabPedrosa ,

you've got a typo in the expression you shared:

Slplit(items('Aplicar_a_cada')?['ID_LojaPresenca'],'-')[1]

Slplit -> Split

But if I understand your flow correctly you want to split ID_FolhaPresenca, not ID_LojaPresenca. ID_LojaPresenca seems like the SP column you want to update.

[RitabPedrosa]

Thanks!! 🙄  🤣