The Data Source You're Updating Expects a 'Record' Type and You're Using a 'Image' Type

[KrypticSloth]

Trying to send information off to my SharePoint site with the information in my collection, but I'm getting an error stating my SharePoint field is expecting a Record, but I'm sending it an Image. I already checked and my SharePoint is set to Image, so I'm not sure why I'm getting this response. Here is my code I'm having issues with:

ForAll(ExpenseReports, Collect('Expense Report List', {ID: MaxID, Title: Gallery3.Selected.'Expense Report Number', Date: Gallery3.Selected.'Transaction Date', Comment: Gallery3.Selected.'Requestor Comment', UserName: Gallery3.Selected.Requestor, ExpenseName: ExpenseNameInput.Text, ExpenseType: ExpenseTypeInput.Selected.Value, PaymentMethod: PaymentMethodInput.Selected.Value, ExpenseCost: ExpenseCostInput.Text, Receipt: Image1.Image});

[WarrenBelz]

Hi @KrypticSloth ,

Before I get to the image, you are missing a closing bracket on that (maybe a mistype in the post), you are using Collect (you are making a Collection) rather than Patch to write data to a Date Source (I assume ExpenseReports is a Collection and 'Expense Report List' is your data Source ), and you cannot Patch the ID in SharePoint unless you are giving it the existing actual record ID to update the record (not MaxID which is the one value).

However your question is around the Image which seems to be the same image for all records, can you please detail what it is you are trying to do here with ExpenseReports and how you collect this data.

[KrypticSloth]

Hello @WarrenBelz 

I'll admit that I am fairly new to all the syntax of PowerApps and still trying to find what works best for what, and I will admit my application is a bit convoluted. The MaxID shouldn't have been there, it should have been Gallery3.Selected.ID because I want reference to the specific item these line items are on. 

I have a Gallery that is being populated with: "Filter(ExpenseReports, !IsBlank(ExpenseName)&& Gallery3.Selected.ID = ThisRecord.ID)", in which I can create a new expense from there and when I'm done creating all the expense's for the expense report in question, I wanted to push that data to my SharePoint data source. For the whole application I can create an expense report, in which I can create multiple expense items attached to that report. When I have all the expenses created, I wanted to loop through them all and send them to my SharePoint site. 

If you want more information for the whole application, I will go ahead and explain, but I figured I'd save you the trouble of reading through all of that and just explain what I need assistance with. 

[WarrenBelz]

Hi @KrypticSloth ,

OK - things are still fairly unclear to me

Are you writing back to update the same records in the Data Source you have collected (you are not writing new records) and if so, are you wanting to update all records from the gallery.

Is ExpenseReports a Collection - if so, do you collect it from 'Expense Report List'

I am more confused at the Gallery Items

Filter(
   ExpenseReports, 
   !IsBlank(ExpenseName)&& 
   Gallery3.Selected.ID = ThisRecord.ID
)

as unless this is a Nested gallery, it is referring to itself in the last line.

Are you using the same Image for all records ? As a start here, if you were patching from the Gallery (and had changed any items in here)

Patch(
   'Expense Report List',
   ForAll(
      Gallery3.AllItems As aPatch,
      {
         ID: aPatch.ID,
         Title: aPatch.'Expense Report Number', 
         Date: aPatch.'Transaction Date', 
         Comment: aPatch.'Requestor Comment', 
         UserName: aPatch.Requestor, 
         ExpenseName: ExpenseNameInput.Text, 
         ExpenseType: ExpenseTypeInput.Selected.Value, 
         PaymentMethod: PaymentMethodInput.Selected.Value, 
         ExpenseCost: ExpenseCostInput.Text, 
         Receipt: Image1.Image
      }
   )
);

any items without aPatch in front of them are assumed not to be in the Gallery (if they are add aPatch. to them). I am also assuming Receipt is an Image column in 'Expense Report List'.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[KrypticSloth]

@WarrenBelz I do apologize that I haven't been exactly clear with everything, I didn't want to have to send everything I had across, but I'll go ahead with that now.

So I have 4 Screens for my Application, 2 are galleries, and 2 are forms. I have 'Home Screen', 'Create Expense Report', 'Expense Report Page', and 'Expense Report Line Item'. In the app, I'm using a data source from SharePoint called 'Expense Report List' and created a collection called ExpenseReports. You are correct to assume that Receipt in the SharePoint is an Image field.

On the Home Screen Page, I have a Gallery and an option to create a new report, which will go into the Create Expense Report screen. Here is what I have for this page:

Gallery: 
Sort(Filter('Expense Report List', !IsBlank('Expense Report Number') && Requestor = User().FullName),ID, Descending)

Create Expense Report: 
Set(LastScreen, "Home Screen");NewForm(Form2);Navigate('Create Expense Report', ScreenTransition.Cover);ClearCollect(ExpenseReports, {ID: 0, Title: "", Date: Today(), Comment: "", UserName: "", ExpenseName: "", ExpenseType: "", PaymentMethod: "", ExpenseCost: "", Receipt: ""});If(CountRows('Expense Report List') > 0, Set(MaxID, Max('Expense Report List', ID) + 1), Set(MaxID, 1042))

Home Screen: https://i.imgur.com/wWsF5Kp.png

On the Create Expense Report page, I have a form that you can fill out the Report Name, Transaction Date, and the Requestor Comment to the manager about this report, if they have one. From there, I have an option to cancel, which goes back to the home page and resets the form, or a "Create" button, which will create the main expense report with the following information:

Create Expense Report Screen: https://i.imgur.com/zTNxXxy.png

Create: Set(LastScreen, "Create Expense Report");Collect(ExpenseReports, {ID: MaxID, Title: ReportNameInput.Text, Date: DateValue(DateValue3), Comment: RequestorComment.Text, UserName: Requestor.Text});SubmitForm(Form2);Navigate('Expense Report Page', ScreenTransition.Cover)

Once that is done, it will take you to Expense Report Page, which you will now be in that gallery-selected item. On this page, at the top it will show the information on the specific Expense Report you're on, at the bottom there is a Gallery that will display the current Expenses you have attached to this Expense Report, and give you the option to create a new expense, as well as submit the entire report. Each item at the top there is a switch statement to describe how the data is being filtered in, from the Create Expense page or from the Home Page, as the home page you can go into the specific report as well. I'll show in example here:

Expense Report Page: https://i.imgur.com/S3HtqgW.png

Expense Report Info: Switch(LastScreen, "Home Screen", Gallery3.Selected.'Expense Report Number', "Create Expense Report", Form2.LastSubmit.'Expense Report Number', "New Line Item", Gallery3.Selected.'Expense Report Number')

Gallery Information: Filter(ExpenseReports, !IsBlank(ExpenseName)&& Gallery3.Selected.ID = ThisRecord.ID)

Submit Button information (Currently working on so might not be the same as before): ForAll(ExpenseReports, Collect('Expense Report List', {ID: Gallery3.Selected.ID, 'Expense Report Number': Gallery3.Selected.'Expense Report Number', TransactionDate: Gallery3.Selected.TransactionDate, RequestorComment: Gallery3.Selected.RequestorComment, Requestor: Gallery3.Selected.Requestor, ExpenseName: ExpenseNameInput.Text, ExpenseType: ExpenseTypeInput.Selected.Value, PaymentMethod: PaymentMethodInput.Selected.Value, ExpenseCost: ExpenseCostInput.Text, Receipt: Image1.Image});

Right now I don't have the ability to go back into a created expense, but when I do I think I'll be adding a switch statement there as well to see if I need to pull the information and fill the expense page to be able to edit it or if it's a new expense or not. Either way, on the Expense Report screen, you have the ability to create a new expense which takes you to the Expense Line Item screen. On here, It gives you the option to create an Expense Name, upload an image of your receipt, give you a drop down menu of choices for Expense Type, give you another drop down for your payment method (Not fully implemented but a "Default" choice was placed in for the meantime), and an Expense Cost. Once you're done filling out that information, there is an option to Cancel and go back to the Expense Page, or Submit the expense to the expense report. This page looks like the following:

Expense Line Item Screen: https://i.imgur.com/81x8EOw.png

Submit: Collect(ExpenseReports, {ID: Gallery3.Selected.ID, Title: Gallery3.Selected.'Expense Report Number', Date: Gallery3.Selected.TransactionDate, Comment: Gallery3.Selected.RequestorComment, UserName: Gallery3.Selected.Requestor, ExpenseName: ExpenseNameInput.Text, ExpenseType: ExpenseTypeInput.Selected.Value, PaymentMethod: PaymentMethodInput.Selected.Value, ExpenseCost: ExpenseCostInput.Text, Receipt: Image1.Image});ResetForm(Form1);

Once that's submitted, it creates a new item in the Expense Report screen's gallery with the new collected information, and from there, once I submit all the expenses, I want to submit the entire report and send that over to the SharePoint site, but that's where I'm running into this issue I came to the forum about. I'm open to all forms of criticism on this because, as I said before, I'm still very new to PowerApps and how everything works, and just want to learn and improve on my skills. If there are any suggestions to make this smoother or anything, please feel free to let me know as well. I believe this is all the information I have on this, but if you need anything else, I'll be more than happy to answer the questions to make sure I can get this working. 

[WarrenBelz]

Hi @KrypticSloth ,

This has morphed from a basic question on patching an Image field to an in-depth analysis of a process flow and to be honest, I do think I can solve it for you without mapping the whole thing out and possibly creating a model. Are we able to concentrate on your posted question - you should be able to Patch an image to an image column - what is stopping you from doing this ?

[KrypticSloth]

When I try to do a patch I get: "The type argument 'field_2' does not match the expected type 'Record'. Found type 'Text'. and I'm not sure what 'field_2' is supposed to be. 

[WarrenBelz]

@KrypticSloth ,

That is a different issue to your Image question - you obviously created you list by importing an Excel sheet (not a good idea as the underlying names of the fields remains at field_xx) and you cannot create an Image column that way, so it must be another field you are having the issue with. If you select each field in your List Settings and then look the end of the URL at the top, you will see the "actual" field name.

[KrypticSloth]

@WarrenBelz 

That is just the error I'm getting when trying to run a patch instead of a collect. I found it was related to an orphaned collection that I created while testing things called "TestCollection" which had a field_2. I didn't pull this from excel because I'm not using excel only the sharepoint page. Only issue is TestCollection is gone now (I had a ClearCollect on the homescreen when it was visible that I got rid of), but I'm still getting the field_2 error with: 

ForAll(ExpenseReports, Patch('Expense Report List', Gallery3.Selected, {'Expense Report Number': Gallery3.Selected.'Expense Report Number', TransactionDate: Gallery3.Selected.TransactionDate, RequestorComment: Gallery3.Selected.RequestorComment, Requestor: Gallery3.Selected.Requestor, ExpenseName: ExpenseNameInput.Text, ExpenseType: ExpenseTypeInput.Selected.Value, PaymentMethod: PaymentMethodInput.Selected.Value, ExpenseCost: ExpenseCostInput.Text, Receipt: Image1.Image})

I checked the list settings and there is nothing by the name of field_2 in the collection I'm trying to patch: List Settings

[WarrenBelz]

@KrypticSloth ,

Did you look at the end of the top URL as I suggested - I just want to make sure there is no field with this "original" name. Whether a collection or the list, the field name must have come from a list somewhere containing that field name. The Error is that field_2 in your collection is Text and that it is expecting a Record in your list - you need to find out which field this is as I cannot do that from here. Did you look in your collection for the field names there ?