Powerapps - Collect to Dataverse + Image

(0) Share

Report

Posted on by CluelessDev

I'm having an issue with trying to use the Collect function to pass an image to my dataverse table.

This is my original collect statement:

Collect('Inspection Records', {Result:DefectMode.Selected.'Defect Mode', Serial:SN.Text, 'Inspection Type':inspectArea.SelectedText.Value, WO:'Work Order'.Text, InspectorID:Employee.Selected.ID,Inspector:Employee.Selected.Name,Ref_Des:Concat(RefDes.SelectedItems, RefID, ", "),BC:BoardC})

I expected that I could add in DefectPicture:'UploadedImage' but it doesn't expect Image type. After searching I saw that the standard practice would be to use PowerAutomate to add the image to the table, however I'm not sure as to how to get the autogenerated rowID from the collect statement just made.

Is it possible to return a Autonumber from a collect function, or is there a better way to upload the image to the row that the data is collected for?

My thought is with the same pushbutton I collect and call function eg.

Collect;

Call Powerautomate function with Image data & RecordID;

Then reset all fields

Is there a way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AaronKGumbs 94 on at

Like (0)

Report
Copy link

Link copied!

Collecting your data changes will only add the amendments to your existing Collection, and not to the Dataverse table. In order to do this you'll need to use Patch to send data back to Dataverse. Have a go at amending your statement to Patch to Dataverse first, and then it'd be worth re-assessing whether you still have trouble with your image and get a similar error, or whether you now have the ability to do so.

Was this reply helpful? Yes No
CluelessDev 4 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure what I'm doing then. I have no patch statements but my data is definitely being added to my custom table as new rows. Is a patch statement something that would be system generated somewhere?

Was this reply helpful? Yes No
AaronKGumbs 94 on at

Like (0)

Report
Copy link

Link copied!

Are you using a Form control hooked up to your custom table? If so, all of this data processing will be happening in the background. The Patch statement allows you to carry out this kind of processing whilst using a custom screen and although it's more time consuming to create, sometimes it can get around the Form control's limitations.

Was this reply helpful? Yes No
CluelessDev 4 on at

Like (0)

Report
Copy link

Link copied!

It's a powerapps canvas? The form control being the push button?

The push button:
If(IsBlank(DefectMode.Selected.'Defect Mode'),Pass, Set(DefDetails,Concatenate(DefDetails, "Result: " , DefectMode.Selected.'Defect Mode' ," Ref Des: ", Concat(RefDes.SelectedItems, RefID, ", "),Char(13))));
If(IsBlank(DefectMode.Selected.'Defect Mode'),Pass, Collect('Inspection Records', {Result:DefectMode.Selected.'Defect Mode', Serial:SN.Text, 'Inspection Type':inspectArea.SelectedText.Value, WO:'Work Order'.Text, InspectorID:Employee.Selected.ID,Inspector:Employee.Selected.Name,Ref_Des:Concat(RefDes.SelectedItems, RefID, ", "),BC:BoardC}));
If(IsBlank(DefectMode.Selected.'Defect Mode'),Pass,Reset(RefDes));
If(IsBlank(DefectMode.Selected.'Defect Mode'),Pass,Set(BoardC,0));
If(IsBlank(DefectMode.Selected.'Defect Mode'),Pass,Reset(DefectMode));

Was this reply helpful? Yes No