web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Getting attendence rep...

Power Automate - Building Flows

Unanswered

Getting attendence report from teams to sharepoint list

(0) Share

Report

Report

Posted on by Community Power Pla...

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'split(item(),decodeUriComponent('%09'))[1]' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 32,846 Most Valuable Professional on at

Like (0)

Report
Re: Getting attendence report from teams to sharepoint list

Hi @Anonymous,

It looks like it cannot find your split character %09 (Tab). That's why it fails to retrieve a second item after splitting, because it can't split in the first place.

You can use an indexOf function to check if the item actual has a %09 character.

Try something like below.

if(equals(indexOf(item(), decodeUriComponent('%09')), -1), item(), split(item(),decodeUriComponent('%09'))[1])

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 788 Super User 2025 Season 2

#2

Tomac 452 Moderator

#3

developerAJ 302

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans