Issue with populating Animals table

[Oyin]

I have this issue with populating my Animal Details table with the csv data. Each time I try to import, only 4 rows are successful. I deleted the 4 from the csv file, reimported, then nothing came in. Also there was no error message. It happened with the Foster Family table as well that 25 out of 30 rows were imported. But that was not a problem since I could input the remaining 5 manually.

Now the Animal table has 50 rows, how can i resolve this?

All the while I've been working with these 4 rows so that I can move on to other tasks due to time constraints. I have been reimporting and hoping that it will work soon but to no avail. Now I'm trying to do the final task and I need more data to have a robust Power Bi analysis.

Help needed pls!

[AhmedSalih]

Hello, @Oyin, I think you are filtering the view that show the data to "Ready for Foster" status. In Dataverse, go to your table and check your view. 

---

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[Oyin · Accepted solution]

Thanks for the reply @AhmedSalih,

Yes, I filtered my canvas app to show my Ready to Foster view, but that's different from the Paw&Heart view in my screenshot.

The Paw&Heart view in my screenshot is same as the Active views. I only saved as Paw&Heart, it has no filter.

I then manually changed the status of the 4 animals that got imported to Ready to Foster so that I would have them all show up in the canvas app for testing.

The main issue was that after submitting for import, clicking on the 'Track Progress' button did nothing and I couldn't see the errors. Since the page wasn't coming up, I couldn't figure out why it would import only those 4 rows.

However, when I tried again this afternoon, the page miraculously appeared. So it was due to data source date format not matching with my environment settings. Even though the format was already set to English (US), still I needed to choose format that matched the csv table dates.

The issue is now resolved, thank you.

[samegatse]

Thanks life saver. It has helped me

[Oyin]

Happy to hear that

[samegatse]

Hi @Oyin Now  how do i configure my adopt button to bring out the form to be filled and submit and then update the shelterstatus column please