cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tdorscher
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

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
PowerAddict
Super User
Super User

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

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.

 

 

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

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,651)