News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Returning null value

Power Automate - Using Flows

Unanswered

Returning null value

(0) Share

Report

Report

Posted on by AI14

17

Hi

I have 2 variables that are strings. the flow runs smoothly up until it needs to add a row in excel.

it outputs values as null when it shouldn't, all sections of form has been filled out.

do i need to add a formula/expression to each value?

outcome - used for switch

responses - used for condition output

please assist.

kr

AI14

All responses Img

All responses (4)

Answers Img

Answers (0)

AI14 17 on at

Like (0)

Report

Re: Returning null value

But the value is not empty?
AI14 17 on at

Like (0)

Report

Re: Returning null value

would it be easier if i changed the response variable from string to array or something? then used another set variable to hold all the data?

would this allow me to choose data from the form based on that one variable?

kr,
AI14
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report
Re: Returning null value

Hi @AI14

Before parsing date, you need to check if the input value is null or not. You may use below expression to fix this issue:

if(equals(item()?['DateCol'],null),'',parseDateTime(item()?['DateCol']))

pls replace item()?['DateCol'] with actual variable in the above expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks
Chriddle 7,669 Super User 2025 Season 1 on at

Like (0)

Report

Re: Returning null value

As stated in the error message, the date value you entered into the parseDate function is null.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,645 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans