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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need to extract the sp...
Power Automate
Unanswered

Need to extract the specific table under the header using PAD

(0) ShareShare
ReportReport
Posted on by 2
I have a PDF with maximum of 6 pages. I need to extract the table(not in table format, looks like text with rows and columns) under the specific header.
Sample content - Here the header is Holiday Holiday : Year:2022

Holiday : Year:2022
S:No Holidays occurring on weekends Date Day
1 New Year 1-Jan-2022 Saturday
2 Makara Sankranti ( for Karnataka) 15-Jan-2022 Saturday
3 Pongal 2-Apr-2022 Saturday
4 May day 1-May-2022 Sunday
5 Mother's day 8-May-2022 Sunday
6 Father's day 19-Jun-2022 Sunday

Unwanted text to ignore Unwanted text to ignore

Unwanted text to ignore Unwanted text to ignore

Holiday : Year:2022
S.No Holidays occurring on weekends Date Day

7 Bakrid 10-Jul-2022 Sunday
8 Parents day 24-Jul-2022 Sunday
9 Maha Saptami /Gandhi Jayanti 2-Oct-2022 Sunday
10 Valmiki Jayanthi / Milad-un-Nabi (Bday of Prophet ) 9-Oct-2022 Sunday
11 Men's day 19-Nov-2022 Saturday
12 Disability Day 3-Dec-2022 Saturday
13 Christmas 25-Dec-2022 Sunday

Unwanted text to ignore Unwanted text to ignore

Unwanted text to ignore Unwanted text to ignore

 

Could anyone please check on this

 

I have the same question (0)
  • VJR Profile Picture
    7,635 on at

    Is your PDF text based or image based?

    Have you tried any of the PDF extraction actions and what are your findings?

     

     

    Also the latest release has the "optimise for structured data" option.

    VJR_0-1653363256457.png

     

  • mahajeeva031 Profile Picture
    2 on at

    Thanks for the reply. Text Based PDF.I cant see "Optimize for structured data" in my version. Might be I need to update. I will check and post.

  • VJR Profile Picture
    7,635 on at

    Your options might also be to extract the text and then using Parse text action or regex retrieve the desired data.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 167

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard