collect won't update data source (CDS)

(0) Share

Report

Posted on by Caroline

171

Hi there

I have the following collect formula:

Collect(test_Course_Link,{Test_A2:LearnerID.Selected,IntakeNumber:IntakeNumberEnrol.Selected.Value, test_Courses:CourseIDEnrol.Selected, SWN:SWNInput.Text})

There is no error warning on the formula, and when I test it, it seems be doing something, but the test_Course_Link entity isn't being updated.

I tested it by changing test_Course_Link for a collection (test_collect), and it worked fine, so I tried to then push the collection back to the entity by using:

ClearCollect(test_collect,Test_A2:LearnerID.Selected,IntakeNumber:IntakeNumberEnrol.Selected.Value,test_Courses:CourseIDEnrol.Selected, SWN:SWNInput.Text});Collect(test_Course_Link,test_collect)

Same problem - still not updating the data source.

Any ideas on what is happening here?

(Yesterday, it would update the data souce, but with the two lookup fields (Test_A2 and test_Courses) ommited. I can't be sure though that the formula is exactly the same, as I have spent quite a bit of time playing around trying to fix it)

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Caroline,

Among Collect, Clear, and ClearCollect functions, you can only use Collect function to add records to a data source. You can also use the Patch function to create records in a data source.

Are LearnerID/IntakeNumberEnrol/CourseIDEnrol all dropdown controls? What are the DATA TYPES of Test_A2/IntakeNumber/test_Courses fields in this entity? Notice that when you add a record to entity, all the Required fields must be included.

Regards,

Mona
Caroline 171 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-monli-msft Thanks Mona. As you will see from the two formulas I tried, it was the Collect command that I was using to write a new record to the data source. (Please disregard the emojis - It has replaced my colons followed by 'S'.)

LearnerID/IntakeNumberEnrol/CourseIDEnrol are all dropdown controls.

Test_A2 and test_Courses fields are Look ups in the entity, and IntakeNumber is a text field (because the number is hyphenated, it can't be a number field)

Cheers