You’re offline. This is a read only version of the page.
Announcements
i want to extract a word from table and share only the specific time zone in SharePoint from power automate
Time Zone Offline Time Anticipated Online Time
Hawaii 07/20 06:00 PM 07/20 09:00 PM
Alaska 07/20 08:00 PM 07/20 11:00 PM
Pacific 07/20 09:00 PM 07/21 12:00 AM
Mountain 07/20 10:00 PM 07/21 01:00 AM
Hi @reshmamohan,
Could you please tell me which word do you want to extract from the email body?
The expression in the "Hawaii" part as below:
Share
Report
All responses (
Answers (
first(skip(split(first(split(body('Html_to_text'),'Alaska')),'Hawaii'),1))
The expression in the "Alaska" part as below
first(skip(split(first(split(body('Html_to_text'),'Pacific')),'Alaska'),1))
The expression in the "Pacific" part as below:
first(skip(split(first(split(body('Html_to_text'),'Mountain')),'Pacific'),1))
The expression in the "Mountain" part as below:
first(skip(split(body('Html_to_text'),'Mountain'),1))
378
