cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerApps does not recognize date when writing to sharepoint

Hi again,

I am looking for some help as I have not found an answer. I am trying to write some data from my App to a sharepoint list. Most of the data works fine as it is just plain text. However, the date refuses to work. I tried converting the date to text by adding it to a label but that didn't work either.

The field in Sharepoint is RequestReceived and I have tried:

  • (with a date picker as the source) Patch('List Name',Defaults('List Name'), {Title:ProjectName:ProjectName.Text, RequestReceived: ReqReceived.SelectedDate})
    • This tells me the field does not exist in SharePoint...yet it does
  •  (Sending the selected date to a label for text) Patch('List Name',Defaults('List Name'), {Title:ProjectName:ProjectName.Text, RequestReceived: ReqRecTxt.Text})
    • This also tells me the field does not exist in Sharepoint

Everything else seems to write fine. If I don't add  .SelectedDate  or  .Text  then the error goes away but unsurprisingly the field does not populate.

 

Any help you can provide would be greatly appreciated.

Cheers!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: PowerApps does not recognize date when writing to sharepoint

Hardit,

Thank you for your willingness to help. I really do appreciate it. I did try it with just that field and had no luck as I was getting the same errors. I saved the app, closed it and restarted it to edit again...same issue. I decided to just delete the column in the SP List and recreate it. It worked! I had a couple of others that were giving me grief as well so I deleted those and recreated them. All is now well and it is (almost) working the way I want it to. 

 

Again, thank you for taking your time to help.

 

Cheers!

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: PowerApps does not recognize date when writing to sharepoint

Hi, all of this points to the fact that the field doesn't exist in your list, at least not with the name you are using in Patch. Can you double check if the field name is the same as in your Patch function?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
Highlighted
Frequent Visitor

Re: PowerApps does not recognize date when writing to sharepoint

I have checked, re-checked and checked again that my spelling was correct, that the way the field was set up was correct. Everything is fine. When I remove SelectedDate, it finds the field...when I add SelectedDate back in PowerApps says it does not exist. I used Date and Time for the field in SP and have tried with Friendly Format on and off. I have turned Include Time on and off. Same result. I have turned the field to Single line text and as I stated earlier converted the date to text and it still throws the error. I have attached a screenshot with the field in SP and the error. I have also copied the name directly from SP into PowerApps and the same error is thrown.

 

 
Highlighted
Super User
Super User

Re: PowerApps does not recognize date when writing to sharepoint

Can you try your Patch with just the RequestRecieved field? Also, in your SPlist, can you go to field settings and show me the details of that field?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
Highlighted
Frequent Visitor

Re: PowerApps does not recognize date when writing to sharepoint

Hardit,

Thank you for your willingness to help. I really do appreciate it. I did try it with just that field and had no luck as I was getting the same errors. I saved the app, closed it and restarted it to edit again...same issue. I decided to just delete the column in the SP List and recreate it. It worked! I had a couple of others that were giving me grief as well so I deleted those and recreated them. All is now well and it is (almost) working the way I want it to. 

 

Again, thank you for taking your time to help.

 

Cheers!

View solution in original post

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (3,709)