Power Automate - Date Modified not pulling in table

Options

I'm very new to this, so the answer might be obvious!

I'm trying to get a simple table emailed to me of all board members, their emails. and the dates their primary email and phone were last modified.

It's working great except the dates are not populating in the table. I'm getting name, email, and blanks. Why are these date fields not carrying over?

I checked that they have valid email addresses (they're listed in the table), and yes, those emails are checked as primary. I tried replacing “date modified” with “date added” and still nothing. Other fields I tested populate just fine, including “date constituent modified”. It just hates email and phone dates. ?

Comments

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary 1,500 Likes 1000 Comments Name Dropper

    @Sarah Krenicki - Can you share a screenshot of the action that's creating the table in edit mode? Essentially I want to see what you've selected to appear in the table.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary 1,500 Likes 2500 Comments Name Dropper

    @Sarah Krenicki
    the email or phone property on a get constituent API endpoint does not provide actual data for date_added nor date_modified

    @Erik Leaver documentation bug to fix?

  • @Austen Brown

    The first screenshot is my list parameters

    the second is the html table I've been playing with (pardon the 0 headers, I've just been swapping out variables to test them)

    the third is the information that gets returned to me: in this case name and constituent date added and modified are appearing, but nothing to indicate address/phone/email has ever been modified - I did also just modify one of them today as a test.

    9617c11972a19e77e955beef5c855c47-huge-im
    9d58b5fb1e58be1c76f6fe765fc9b43b-huge-im


    153f95642652698e40fa43a5cfb40db1-huge-im

Categories