cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PDRC
Helper I
Helper I

How to upload/save a file in dataverse from canvas app(without Power automate)

Hello Everyone,
In canvas I am trying to upload a file from a system and want to store it in dataverse table
The dataverse table has (File name, File type, url)
below is the TextInput to fill for the user and select the file from the system

PDRC_1-1668096542566.png

now
1) when I click on Save I want to send these to the database table, I tried using patch but I was not able to write the query to send the into the database. &
2)once we select file(Ex; resume.pdf ) then it should automatically get the url of that in File URL.
and all I want is to store the input data with resume.pdf in dataverse.

If anyone know please help me out with it.
Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
PDRC
Helper I
Helper I

1) To push the data into the dataverse I used for instead of textbox and used
btnSave-> Onslect->Submit form(FormName),
The patch function also worked as it was having a typing error

Patch(
'Doc',
Defaults('Doc'),
{
'File Name':TextInput1.Text,
File:
{
FileName: First(DataCardValue.Attachments).Name,
Value: First(DataCardValue.Attachments).Value
}
}
);

but still I did not able to added the File type in the dataverse.

2) To get the Url of the uploaded file, I used a Instant flow.

View solution in original post

1 REPLY 1
PDRC
Helper I
Helper I

1) To push the data into the dataverse I used for instead of textbox and used
btnSave-> Onslect->Submit form(FormName),
The patch function also worked as it was having a typing error

Patch(
'Doc',
Defaults('Doc'),
{
'File Name':TextInput1.Text,
File:
{
FileName: First(DataCardValue.Attachments).Name,
Value: First(DataCardValue.Attachments).Value
}
}
);

but still I did not able to added the File type in the dataverse.

2) To get the Url of the uploaded file, I used a Instant flow.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,208)