Skip to main content

Notifications

Power Pages - General Discussions
Suggested answer

Issue with retrieving non-empty cell data in Power Automate

Like (1) ShareShare
ReportReport
Posted on 27 Sep 2024 16:05:05 by 6

Hello everyone,

I’m facing an issue in my Power Automate flow. I’m trying to retrieve the content of a non-empty cell from an Excel file. However, when I run the automation, I get a message saying that the column is empty, even though the cell actually contains data.

Does anyone have any suggestions or tips to resolve this problem?

Thanks in advance for your help!

Categories:
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,559 on 20 Oct 2024 at 13:38:33
    Issue with retrieving non-empty cell data in Power Automate
    trim(triggerOutputs()?['body/ColumnName'])
     
    ColumnName ne ''
     
  • abm abm Profile Picture
    abm abm 32,277 on 01 Oct 2024 at 22:15:54
    Issue with retrieving non-empty cell data in Power Automate
    Need to see the flow to determine what's going? Set the Datetime Format set to ISO8601
     
     
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,367

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,297

Leaderboard

Featured topics

Loading started
Loading complete