Get First table only from Get tables

(0) Share

Report

Posted on by CharlesBrewer

697

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 697 on at

Like (0)

Report
Copy link

Link copied!

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 697 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!
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,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 697 on at

Like (0)

Report
Copy link

Link copied!

Thanks @wskinnermctc noted for next time!

Was this reply helpful? Yes No