web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / list rows of the curre...
Power Automate
Unanswered

list rows of the current table in a loop

(0) ShareShare
ReportReport
Posted on by 4

Hey guys,

like the name says, im running into a problem, where Im trying to list rows of a table inside a loop. I have multiple excel tables which have the same name as a given task I want to update in Planner. So in order to get through all of it, I tried to use a apply-to-each loop to iterate through the tasks and the a second apply-to-each to iterate through all tables. When the tablename eq the taskname it should start with a list rows of current table action, which should be the current element of the second apply-to-each loop, but as soon as the value hits true and the action tries to start, it fails with this response:

 
BadRequest. Http request failed: the content was not a valid JSON. Error while parsing JSON: 'After parsing a value an unexpected character was encountered: @. Path 'message', line 1, position 71.'
 
The error message:
Badturkey_0-1698682340591.png

 

I dont get why it generates such a response, since the values of the given actions were generated by Power Automate/Microsoft itself.  Does anybody have an idea how I can solve this problem? 

Categories:
I have the same question (0)
  • fchopo Profile Picture
    8,003 Moderator on at

    Hi @Badturkey 

    Please, check you don't have any special character in the Excel file or try to recreate the action.

    Hope it helps!

    Ferran

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard