cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kimkantola
Level: Powered On

Attachments uploaded via PowerApp to CDS Entity

Hello All,

 

I have seen several posts on this subject but can not seem to solve my problem.  If anyone can see where I may have taken a wrong step along this path, could you let me know?

  1. I have created a CDS Entity, called "Purchase" and Enabled Attachments for it
  2. I have created a PowerApp which has a Screen that contains a Form, the datasource for that form is my Entity I created in step one.
  3. When I enter data into my form, upload a file, and submit the form, I can see that rows have been added to the Purchase Entity, And also my upload information has been added to the Notes Entity
  4. NoteEntity.jpeg
  5. In the notes entity, I can only see the file Name and title, when I select the "All Fields" filter, this clears out the data and no rows are shown, the page is just blank
  6. All Notes Drop Down :  AllNotes.jpeg
  7. Empty Notes Screen, no data :Empty.jpeg
  8. For some reason, if I exit the Power Apps console all together and go back in, I can see my data in my "Purchase Entity" but the Notes screen shows no data anymore.
  9. Lastly,  I am confused about where the actual uploaded file is stored.  I thought it would go into the "Attachments" Entity, but that is empty.  I can see info about the file in the Notes entity (before it clears out) , like the File Name, but I don't know where the actual file data is.

 

Thank you so much if anyone can help out.

~Kim

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Attachments uploaded via PowerApp to CDS Entity

Hi @kimkantola ,

I've made a similar test but not met the problem like your description.

Please check these points:

1)Has your file uploaded successfully?

2)Does the file still exist in the "purchase" entity? You could check it in PowerApps.

3)Have you enable attachments?5221_LI.jpg

What's more, the attachements when you enable the Notes and Attachements, are saved to the Note entity, that is related automatically with that entity. And the file's content is saved in the DocumentBody field in the format of binary.

Here's doc for your reference:

https://powerapps.microsoft.com/en-us/blog/add-attachments-to-your-common-data-service-entities/

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/reference/entities/annotati...

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kimkantola
Level: Powered On

Re: Attachments uploaded via PowerApp to CDS Entity

Hello!
Thank you so much for your reply and help.

I did eventually see the  document I uploaded  get stored into the Notes entity.  It must have been a lag time for Azure to catch up. I logged back in a few hours after making this post and and could see a lot more information in the Notes Entity.

 

I had uploaded several doc's while testing and I am guessing that the web.powerapps portal just couldn't access all the data for a bit.  I can now see a Mime type column, a Document column, etc.

 

Hoping this post helps someone in the future, looks like all was working as I would have expected it, but some sort of lag was making it take a while for the data to actually show up when I was looking at the entities in the webapps environment.

3 REPLIES 3
kimkantola
Level: Powered On

Re: Attachments uploaded via PowerApp to CDS Entity

Hi All,

 

Posting some new info in case anyone else hits this same  problem.

It does look like the document also does get stored into the Notes entity in binary form.  It must have been a lag time for Azure to catch up. I just logged back in and can see a lot more information in that Entity.

 

I had uploaded several doc's while testing and I am guessing that the web.powerapps portal just couldn't access all the data for a bit.  I can now see a Mime type column, a Document column, etc.

 

Hope this helps someone!

 

 

Community Support Team
Community Support Team

Re: Attachments uploaded via PowerApp to CDS Entity

Hi @kimkantola ,

I've made a similar test but not met the problem like your description.

Please check these points:

1)Has your file uploaded successfully?

2)Does the file still exist in the "purchase" entity? You could check it in PowerApps.

3)Have you enable attachments?5221_LI.jpg

What's more, the attachements when you enable the Notes and Attachements, are saved to the Note entity, that is related automatically with that entity. And the file's content is saved in the DocumentBody field in the format of binary.

Here's doc for your reference:

https://powerapps.microsoft.com/en-us/blog/add-attachments-to-your-common-data-service-entities/

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/reference/entities/annotati...

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kimkantola
Level: Powered On

Re: Attachments uploaded via PowerApp to CDS Entity

Hello!
Thank you so much for your reply and help.

I did eventually see the  document I uploaded  get stored into the Notes entity.  It must have been a lag time for Azure to catch up. I logged back in a few hours after making this post and and could see a lot more information in the Notes Entity.

 

I had uploaded several doc's while testing and I am guessing that the web.powerapps portal just couldn't access all the data for a bit.  I can now see a Mime type column, a Document column, etc.

 

Hoping this post helps someone in the future, looks like all was working as I would have expected it, but some sort of lag was making it take a while for the data to actually show up when I was looking at the entities in the webapps environment.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 192 members 4,359 guests
Please welcome our newest community members: