How to save an image uploaded on a canvas app to a dataverse table

(0) Share

Report

Posted on by JohnM86

590

Hi everyone,

I hope you are all well.

I am having issues getting a lookup field and image to save from the canvas app to the corresponding table in dataverse. The expression I am using is :

Patch(Expenses, Defaults(Expenses), {Name: User().FullName, Types: LookUp('Expense Types', 'Expense Type Name'=ListBox1.Selected.'Expense Type Name'), amount: TextInput1.Text, 'Receipt Image': AddMediaWithImage3}); Reset(ListBox1); Reset(TextInput1);

If(IsEmpty(Errors(Expenses)),

Navigate(success),

Notify(First(Errors(Expenses)).Message));

However, when it saves it is saving all data as expected minus the uploaded image and the lookup field. With this in mind, I am hoping one of you can point me in the right direction, I have spent the day searching various posts but so far nothing has worked.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

JohnM86 590 on at

Like (0)

Report

Morning all,

I have managed to get the image to save now with:

Set(_addfile,JSON(Image16.Image,JSONFormat.IncludeBinaryData));Set(_base64File,Mid(_addfile,Find(",",_addfile)+1,Len(_addfile) - Find(",",_addfile)-1)); Set(_upload,false);Patch(Expenses, Defaults(Expenses), {'Receipt Image':{Value:Image16.Image,Full:Image16.Image}, Name:User().FullName, Types: LookUp('Expense Types', 'Expense Type Name'=ListBox1.Selected.'Expense Type Name'), amount: TextInput1.Text}); Reset(ListBox1); Reset(TextInput1);
If(IsEmpty(Errors(Expenses)),
Navigate(success),
Notify(First(Errors(Expenses)).Message));

However, the only issue is still the value from the lookup field

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @JohnM86

Please mark it as solution, that will help the community. 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
JHS2019 30 on at

Like (0)

Report

Can you display how you have added in the app?

Was this reply helpful? Yes No