Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Trying to pass Date from powerapps to Flow to Sharepoint

Like (1) ShareShare
ReportReport
Posted on 29 Dec 2022 21:39:42 by 19

I have what I thought would be a simple PowerApps App that collects a few pieces of information and uploads this to SharePoint. I found that since I am including a picture from the camera control I needed to do this with a Flow. The date fields were being passed to the run command from a DatePicker using DatePicker.SelectedDate. For the Flow, I tried to use:

formatDateTime(triggerBody()['Updatefileproperties_ReportDate'],'MM-dd-yyyy')

in the expression field but I ended up with the following error in PowerApps:

pmontalbano_1-1672348909555.png

Then I decided to hard code the date as string and use variables in the flow to take a string date and convert to Date. then add the Date to the File Properties Update. The flow now contains:

pmontalbano_2-1672349532224.png

pmontalbano_3-1672349558424.png

This produces the exact same error from PowerApps. To make matters worse, when I look at the 28 day run history, none of my attempts show up. There are only two entries and both are from tests I performed, not from the manual action from PowerApps. So I have 2 questions:

1. how can I pass the DatePicker.SelectedDate to the Flow to end up in a Date column in SharePoint?

2. Why am I not seeing the Flows fail? In fact, no matter what change I make in PowerApps or in Flow, the error message I get is exactly the same. This seems very strange to me.

 

Bonus points for anyone that can tell me how to update only a subset of fields when creating this record as some fields in SharePoint are not required and will be modified later by users directly in SharePoint.

 

 

  • Verified answer
    pmontalbano Profile Picture
    19 on 01 Jan 2023 at 02:21:44
    Re: Trying to pass Date from powerapps to Flow to Sharepoint

    Solved it. Instead of passing 

    DatePicker1.SelectedDate

     I am now passing

    Text(DatePicker1.SelectedDate, "yyyy-mm-dd")

    This sends the correct format to flow and the flow now works.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 367 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 193

#3
stampcoin Profile Picture

stampcoin 147

Overall leaderboard
Loading complete