welcome to XRM blog

Keep in touch with latest CRM/ERP articles

To remain competitive your organisation must be efficient across the business process spectrum. To do so you need to take sound decisions based on a balance between the cost and risk. To do so you will be heavily dependent on your content management in itself needs...

image
Blog

How to create a File Type Field in CRM

By Ishaan Sheikh on 12/31/2020

1.     Creating a File Type Field

·         To create a file type field, from your CRM home window, navigate to “Power Automate”.

 

·         Go to Solutions and select your solution to make your customizations.

NOTE: Make sure you are in the right environment as your current CRM’s environment.

 

·         Add a Table (entity) in which you want to add the file type column (field) into it.

·         Now click on Add Column to create a field, and give an appropriate name for the field. Also, make sure to select the data-type as “File”.

 

·         Click Done.

 

2.     Adding a Column in the Form

·         To add a column in your form to display, navigate to your form from Power Automate.

·         And edit your form. And Click on Table Columns.

 

·         Add your newly created field into your form then click Save and Publish.

·         Now, you will be able to upload and store a file relating to your entity’s record.

 

·         You can also be able to delete the uploaded file and re-upload another file instead of it.

 

3.    Accessing the File-type column

To access the uploaded file’s content using JavaScript, you can send a request to the following Web API URL:

·         To get the file’s content in base64 string, go to:

https://<your-org-url> /api/data/v9.1/<entityname>(<record-GUID>)/<field-schema-name>?size=full

For example,

https://exampleorg.crm.dynamics.com/api/data/v9.1/accounts(aaa19cdd-88df-e311-b8e5-6c3be5a8b200)/new_uploadpdf?size=full

·         For simply downloading the file, go to:

https://<your-org-url> /api/data/v9.1/<entityname>(<record-GUID>)/<field-schema-name>/$value

For example,

https://exampleorg.crm.dynamics.com/api/data/v9.1/accounts(aaa19cdd-88df-e311-b8e5-6c3be5a8b200)/new_uploadpdf/$value

 

Javascript
HTML 5
Dynamics CRM
Dynamics 365
file-upload
Javascript
powerapps
Blog Calendar
Blog Calendar List
2023 Nov  17  7
2023 Oct  58  16
2023 Sep  48  9
2023 Aug  45  7
2023 Jul  31  5
2023 Jun  20  4
2023 May  43  5
2023 Apr  23  5
2023 Mar  66  6
2023 Feb  62  5
2023 Jan  31  4
2022 Dec  94  7
2022 Nov  221  2
2022 Sep  13  1
2022 Aug  26  2
2022 Jun  7  2
2022 May  3  2
2022 Apr  5  2
2022 Mar  1  1
2022 Feb  2  1
2022 Jan  1  1
2021 Dec  3  1
2021 Nov  2  1
2021 Oct  1  1
2021 Sep  11  1
2021 Aug  37  5
2021 Jul  36  4
2021 Jun  1024  5
2021 May  30  3
2021 Apr  1795  3
2021 Mar  176  5
2021 Feb  1724  7
2021 Jan  2338  9
2020 Dec  381  7
2020 Sep  72  3
2020 Aug  615  3
2020 Jul  120  1
2020 Jun  65  3
2020 Apr  58  3
2020 Mar  12  2
2020 Feb  27  5
2020 Jan  34  7
2019 Dec  17  4
2019 Nov  23  1
2019 Jan  23  2
2018 Dec  48  4
2018 Nov  68  3
2018 Oct  18  3
2018 Sep  1065  11
2018 Aug  7  2
2018 Jun  12  1
2018 Jan  68  2
2017 Sep  583  5
2017 Aug  17  1
2017 Jul  17  2
2017 Jun  62  2
2017 May  21  1
2017 Apr  35  2
2017 Mar  129  4
2017 Feb  737  4
2016 Dec  200  3
2016 Nov  755  8
2016 Oct  297  10
2016 Sep  612  6
2016 Aug  39  1
2016 Jun  1854  6
2016 May  109  3
2016 Jan  71  2
2015 Dec  421  6
2015 Nov  4  1
2015 Oct  13  1
2015 Sep  1458  6
2015 Aug  14  1
2015 Jul  128  2
2015 Jun  10  1
2015 May  20  1
2015 Apr  30  3
2015 Mar  80  3
2015 Jan  5329  4
2014 Dec  17  1
2014 Nov  2257  4
2014 Oct  67  1
2014 Sep  107  2
2014 Aug  5224  1
2014 Jul  48  2
2014 Apr  2566  12
2014 Mar  295  17
2014 Feb  219  6
2014 Jan  1510  16
2013 Dec  21  2
2013 Nov  688  2
2013 Oct  256  3
2013 Sep  11  1
2013 Aug  40  3
2013 Jul  214  1
2013 Apr  57  6
2013 Mar  2252  10
2013 Feb  127  3
2013 Jan  327  2
2012 Nov  56  2
2012 Oct  496  10
Tag Cloud
Interested in our services? Still not sure about project details? get a quote