web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Two Compose Actions - ...

Power Automate

Answered

Two Compose Actions - First one succeeds but the second fails

(0) Share

Report

Report

Posted on by Yoshimitsu411

82

Hi All

I have two compose actions in my flow, one for Scheduled Date and one for Actual Release Date with the following code:

if(empty(items('Apply_to_each')?['Scheduled Date']),'',addDays('1899-12-30',int(items('Apply_to_each')?['Scheduled Date']),'MM/dd/yyyy'))

if(empty(items('Apply_to_each')?['Actual Release Date']),'',addDays('1899-12-30',int(items('Apply_to_each')?['Actual Release Date']),'MM/dd/yyyy'))

The first one for Scheduled date works perfectly but the secone one for Actual Release Date fails.

Output

I have come across a similar issue here, but it hasn't helped me solve my problem

Any suggesions?

Thank you.

Categories:

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@Yoshimitsu411

Why are you not using the variables that you have set? VarActualReleasedDate in your Compose? You've highlighted them as output but then don't call them in the compose?

Damien
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Yoshimitsu411 ,

May be this aproach will work ...

if(empty(variables('varScheduledDate')),'',addDays('1899-12-30',int(variables('varScheduledDate')),'MM/dd/yyyy'))

if(empty(variables('varActualReleaseDate')),'',addDays('1899-12-30',int(variables('varActualReleaseDate')),'MM/dd/yyyy'))

On the other hand, please check if ['Actual Release Date'] column name isn't somehow misspelled.

Hope it helps !
Yoshimitsu411 82 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @gabibalaban , but it turns out I misspelled the name of the Actual Release Date column.

I could have also used the variable solution pointed out by @DamoBird365

Thanks again.

Yoshi

Join the conversation