Get First table only from Get tables

(0) Share

Report

Posted on by CharlesBrewer

674

Hello,

I am trying to avoid an 'Apply to Each' because I know there is only 1 table in my sheet. From googling I assume I need a First() Function here but I can't seem to get it :

Any help here is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

CharlesBrewer 674 on at

Like (0)

Report

I also tried :
first(outputs('Get_tables')?['body/value'])
But I just get this error :
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.'

I am beginning to think I can't pull the table name this way 😕 To try other things.

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

Nevermind I overthought it. I was able to do 'Table 1' as a custom and that seems fine.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report
If you want to get the name you would use the below expression:
first(outputs('Get_tables')?['body/value'])?['name']

Here it is in a screenshot:
Get First Table

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

I recently uploaded a YT Tutorial that covers how to dynamically select a table. Please reference this part of this part of the video.

Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

Thanks @wskinnermctc noted for next time!

Was this reply helpful? Yes No