Date is not getting displayed in the adaptive card

(1) Share

Report

Posted on by NS-10041416-0

184

Hi,

I have list of users with email addresses, Campaign start date and end date as mentioned below

To achieve this I have set the power automate as mentioned below

Inside Apply to each loop

Inside Adaptive post card

But in the adaptive card, date is not getting displayed as mentioned below. Let me know if I am making mistake here

Regards,

Sudheer

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Tomac 4,061 Moderator on at

Like (0)

Report
Copy link

Link copied!
@NS-10041416-0 Looks like the problem is in two places: Your List Rows action and your addDays expression.

Let's fix them one at a time.

1. List Rows - you'll need to click Show Advanced Options on this action and in DateTime Format choose ISO8601:

2. Now that the dates are being pulled correctly, you don't need to use addDays to modify them, just a formatdatetime() expression to change the date into the format you want:

formatdatetime(items('Apply_to_each')?['CampaignEndDate'],'yyyy-MM-dd')

And that's it! Should solve your problem. This is a common issue that users come to us with, that they were told to do by chatgpt. Please do not use that chatbot for Power Automate, it's really unreliable. If you must use a chatbot, CoPilot is much more reliable for Power Automate (though still regularly wrong - nothing replaces experience)

If this comment resolved your issue, please remember to mark it as the answer.

Was this reply helpful? Yes No
Tomac 4,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

@NS-10041416-0 Given you've moved on to other issues, please come back to this thread and mark the post below as the answer if this issue was resolved. This will help future people who have this problem to find the answer quickly.

Was this reply helpful? Yes No
NS-10041416-0 184 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tomac,

I have made the changes as specified but no luck

In Excel

In Set Variable inside Column End Date

Referred variable in the body of Adaptive card

But unfortunately, below is the final outcome

Was this reply helpful? Yes No
Verified answer

Tomac 4,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

@NS-10041416-0 You need to use the expression editor, not entering the expression as plain text:

Which, when finished, looks like this:

Was this reply helpful? Yes No