Answered

Upon Patch - Server response: A value must be provided for item

(0) Share

Report

Posted on by Piggi

Hello community,

I am trying to update a table in an excel file with patch. No matter what insert, the Server always gives an error "A Value must be provided for item". I tested a version where I left all updates blank and just used Defaults, but even that wont work. I am happy for any comments or ideas 🙂

The table has five colums with the following formats:

Kostengategrie - String
Kosten - Number
Kommentar - String
Eintragsdatum - Date
Fälligkeitsmonat - Date

and I am using the following code:

Patch(
 Reisekostentabelle,
 Defaults(Reisekostentabelle),
 {
 'Kostenkategorie ': Kostenkategorie_Value.SelectedText.Value,
 Kosten: Kosten_Value,
 Kommentar: Kommentar_Value.Text,
 Eintragsdatum: Coalesce(Blank(), Today()),
 Fälligkeitsmonat: Coalesce(Blank(), DateValue1.SelectedDate)
 }
);
Navigate(BrowseScreen1)

Greetings

Lasse

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Piggi ,

Do you mean that you could not update successfully?

Could you tell me:

1)how do you connect with this excel table? choose "import from excel" or connect with one drive?
2)what does Kosten_Value represent?
Please notice that:
if you choose "import from excel" to connect with excel table, then the excel table is read-only. It's a kind of static table that is imported to powerapps' cache, not supported to update.

What's more, if Kosten_Value is the text input's name, you should use textinputname.Text to represent the text in the textinput.

Try this formula:

Patch( Reisekostentabelle, Defaults(Reisekostentabelle), { 'Kostenkategorie ': Kostenkategorie_Value.SelectedText.Value, Kosten: Value(Kosten_Value.text), Kommentar: Kommentar_Value.Text, Eintragsdatum: Coalesce(Blank(), Today()), Fälligkeitsmonat: Coalesce(Blank(), DateValue1.SelectedDate) } ); Navigate(BrowseScreen1)

Best regards,

Was this reply helpful? Yes No
Piggi 16 on at

Like (1)

Report
Copy link

Link copied!

Hey v-yutliu-msft,

sorry for the late reply, but I found at least the problem and some minor workarrounds, whicht are not satisfying to be honest.

To answer your to questions:
1) I connected via One Drive so the "read only" was not the problem.
2) Kosten_Value translates to "costs". Practice your German 😛 but very sharp eye! Kosten_Value will only have numbers in it so it needs to be number. Your tip kind of works. Now the excel gets updated, but the number is always 0 for some reason.

The excel which I used had date, number and text collumns.

After I removed all the formating in the excel and changed the PowerAPP formula all to .Text it worked. After that I had a little try an error run and managed to get at least the date running. You need a "DatePicker2.SelectedDate" if you want to write into an formated Date column. This is a little confusing as the suggested standard is DateValue and not DatePicker. I made a quick screenshot (in German again, sorry...)

Thanks a lot for the help 🙂

Was this reply helpful? Yes No