Newbie here. Collect data is showing incompatible type with data source expecting ‘text’ and using ‘ control’

Like (0) Share

Report

Posted on 14 Jul 2021 23:14:52 by JoeLong

I have a simple canvas app tied to a sharepoint list and trying to finish up and save data entered onto the form.

Collect(‘ListName’,

{Title:User().FullName,

‘Question1’:Column2,

‘Question2’:Column3,});

Navigate(‘SuccessPage’)

I’m getting invalid argument. Incompatible type. The ‘Question1’ column in the data source you’re updating expects a ‘Text’ type and you’re using a ‘Control’ type.

Question1 is a Radio button selection

Question2 is a combobox

i understand the list type may not be compatible but ‘Control’ type is unknown to me.

How do I resolve? Thank you in advance!

Categories:

Connecting to Data

All responses (2)

Answers (1)

Verified answer

v-albai-msft on 15 Jul 2021 at 06:37:38

Like (0)

Report
Re: Newbie here. Collect data is showing incompatible type with data source expecting ‘text’ and using ‘ control’

Hi @JoeLong ,

You need to make sure two things before completing your formula:
1. Which column type you want to save date into.
2. Which control type you are using

Then in your formula, you should save controlname.property(like DataCardValue1.Text) into the specified SP column.

Based on your information, I assume that:
1. Question1 is a Text column, and Question2 is a Choice column in your SharePoint list.
2. Column2 is the name of a TextInput control, and Column3 is the name of a combobox control

So the formula should be like this:

Collect('ListName',{ Title:User().FullName, TextColumn:Column2.Text, ChoiceColumn:{Value: Column3.Selected.Value} }); Navigate('SuccessPage')

See my example, the name of two controls is DataCardValue1 and DataCardValue4:

I want to save value inside control DataCardValue1 into Title column, and save value selected inside control DataCardValue4 into Question1 column. (Title is a Text column and Question1 is a choice column). here is my formula:

Refer to my formula to complete your needs.

Best regards,

Allen
CNT 10,919 Super User 2025 Season 1 on 15 Jul 2021 at 00:25:38

Like (0)

Report

Re: Newbie here. Collect data is showing incompatible type with data source expecting ‘text’ and using ‘ control’

@JoeLong If it is a simple Edit Form, the easiest way to save the data would be using the SubmitForm(formname) function.