RC -> Datum narozeni (PowerAutomate)

flow.md

Clean RC expression

Type: Data Operation Action: Compose

Expression:

replace(replace(outputs('RC'), '/', ''), ' ', '')

Datum narozeni expression

Type: Data Operation Action: Compose

Expression:

formatDateTime(
  concat(
    string(
       if(
          and(
              equals(length(outputs('Clean_RC')), 10),
              less(int(substring(outputs('Clean_RC'), 0, 2)), 54)
          ),
          add(
              int(
                  substring(outputs('Clean_RC'), 0, 2)
              ), 
              2000
          ),
          add(
              int(
                  substring(outputs('Clean_RC'), 0, 2)
             ),
             1900
          )
       )
    ),
    '-',
    string(
      formatNumber(
         sub(
             int(substring(outputs('Clean_RC'), 2, 2)), 
             if(
                greater(
                        int(substring(outputs('Clean_RC'), 2, 2)),
                        12
                ), 
                50,
                0
             )
         )
      ,'D2')
    ),
    '-',
    substring(outputs('Clean_RC'), 4, 2)
  ),
  'yyyy-MM-dd'
)