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
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
124 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
214 | |
181 | |
139 | |
96 | |
83 |