web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Ignore the null value

Power Automate

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'))

Categories:

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sohailcharolia ,

Please try:

Result:

Best Regards,

Bof

Was this reply helpful? Yes No
sohailcharolia 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bof.
Can you please confirm what command you have used in filter array item()

Was this reply helpful? Yes No
sohailcharolia 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bof,

Can you please confirm what command you have used in filter array item()

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sohailcharolia ,

It's just

item()

Best Regards,

Bof

Was this reply helpful? Yes No
sohailcharolia 9 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sohailcharolia 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Can someone please help on my above requirement

Was this reply helpful? Yes No

Join the conversation