News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Ignore the null value

Power Automate - Using Flows

Unanswered

Ignore the null value

(0) Share

Report

Report

Posted on by sohailcharolia

9

I want to ignore the null value that gets created at the end of the file ,""

I have used this command

split(outputs('Get_file_content_using_path')?['body'], decodeUriComponent('%0A'))

All responses Img

All responses (6)

Answers Img

Answers (0)

sohailcharolia 9 on at

Like (0)

Report

Re: Ignore the null value

Can someone please help on my above requirement
sohailcharolia 9 on at

Like (0)

Report

Re: Ignore the null value

Hi,

It is taking null value at the end of the csv file which I want to exclude from my flow. 1st page flow completed successfully but 2nd page gets failed because of null value which I want to exclude.
v-bofeng-msft on at

Like (1)

Report
Re: Ignore the null value

Hi @sohailcharolia ,

It's just

item()

Best Regards,

Bof
sohailcharolia 9 on at

Like (0)

Report

Re: Ignore the null value

Thanks Bof,

Can you please confirm what command you have used in filter array item()
sohailcharolia 9 on at

Like (0)

Report

Re: Ignore the null value

Thanks Bof.
Can you please confirm what command you have used in filter array item()
v-bofeng-msft on at

Like (0)

Report

Re: Ignore the null value

Hi @sohailcharolia ,

Please try:

Result:

Best Regards,

Bof

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,702 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans