Power Platform Community Forum Thread Details

Hi! I have a problem with my form? patch? Honestly, I don't know.

I am making a grading app, where users will choose desired student and then grade them. After that, the students' info and the grading sheet will show up. Once it's all done, user will submit the grades.

The app runs fine before, and when all things were going great, now it won't update the Excel Online anymore.

The weird thing is, the only updated column is for the Score, which is in a number format. The other columns won't update and just stays empty. Already checked they all are in the right format (text) in Powerapps and even the Excel.

What I Submitted :

After Submitting :

You can see the score works perfectly fine, but the other columns just wont show anything.

Here's some info about the problem :

Student_Grade Table :

Student_Data Table :

Grade Screen :

Form Viewer (Up, uses Student_Data)

Item : ComboBox1.Selected

(fyi, the combobox is not inside the form because.. honestly it's even more complicated to connect so idk lets just leave that)

EditForm (Down, uses Student_Grade)

Item : If(!IsBlank(ComboBox1.Selected.ID), LookUp(Student_Grade, ID= ComboBox1.Selected.ID))

Submit Button :

Refresh(Student_Grade);
Patch(Student_Grade, LookUp(Student_Grade, ID = ComboBox1.Selected.ID),
 {
 'Action Task':Value(DataCardValue21.Text),
 Score:Value(DataCardValue20.Text),
 'Overall Comments':Value(DataCardValue19.Text),
 Email:Value(DataCardValue2.Text)
 }) ;

Email DataCardValue (Hidden) :

User().Email

Really need the help for this one, please let me know if you need more info.

Thank you!

Categories:

Building Power Apps