web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Compose tool failing o...

Power Automate

Answered

Compose tool failing on blank excel rows.

(0) Share

Report

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

My compose statement is reading in excel table.

However when it gets to a blank row i get error "Action 'Compose_2' failed"

Is there anyway to bypass this error to deal with blank records?

compose 1 -

items('Apply_to_each')?[concat('Period Planned ', '/', ' Revised Date')]

Compose 2 -

addDays('1899-12-30',int(outputs('Compose')),'yyyy-MM-dd')

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wonka1234 ,

What error message have you received? It should include more description. If Compose is compose1 in your example, then the output is "/" rather than blank if Period Planned and Revised Date fields are blank. If you want Compose2 leaves blank, in case that only one of the two fields is blank, you can use below expression for it:

if(or(startsWith(outputs('Compose'),'/'),endsWith(outputs('Compose'),'/')),'',addDays('1899-12-30',int(outputs('Compose')),'yyyy-MM-dd'))

Best regards,

Was this reply helpful? Yes No

Join the conversation