Submit form Issue

[Fields]

Hey guys, i am very new at the powerapp, and i tried to do an app...

Everything was fine, until the submit button bugged, and when i submit, it cleans all the required fields (Expect the date), and says to do it again! I can't submit, can someone help me?

I have tried everything in the forums and still nothing..

Edited: I don't know if it helps, but it's worth noticing, that i used calculated columns, and data from other list, i don't know if this affects or not...

[Fields]

It works! Thank you for the help, i was getting desperate! Thank you again!

[Tom_Slosse]

Hey @Fields

No problem. Im glad I could help

Kind regards

Tom

[PowerAppMichael]

@Anonymous_Sloss It appears I'm having the same issue with calculated fields as the user Fields was having. I get the general idea of using patch but there's not a lot examples out there of how the "Patch" function works.

I have a form "NewRequestForm" that I'm trying to submit data through into a list "Requests Modern" however there are three calculated fields I have, "Exception", "Completed", and "Current_x0020_Task_x0020_Complet" in the requests modern list.

The original "OnSelect" command I have for the submit button was "SubmitForm(NewRequestForm)" but by this thread it looks like I need to patch the three columns. I'm having a little trouble with the syntax.

The tooltips for the Patch function read as follows "Patch(source,record,update,...)" but that's not mutch to go on. From this thread it looks like Patch will patch the active form and submit into the SharePoint list, which is slightly odd to me that I don't reference my form? It doesn't appear to want it.

From what you last gave a command for it looks like my patch should be "Patch('Requests Modern',Defaults('Requests Modern),...." But then it falls apart for me, mainly because even if I have data cards for the fields they don't appear to take any values. I'd prefer to not have to have datacards for my three calculated columns if possible (but if I must I'll make them invisible), but currently I have them and they don't appear to have an Update attribute. This is all just so confusing. I'd get rid of two of the three calculated columns to fix this situation but the "Current Task Completed" one I really need to be "real time".

Any help would be appreciated!

Thanks! Michael

[Fields]

Hi @PowerAppMichael,

From my point of view, it would be better if you made your own thread! I think since this problem got a solution for me, and it's officially written as solved, i don't think that they are coming here again...

I wish i could help you, but what i can say, it's better have your own thread, there are more chances getting a good answer there than here!

Hope it helps you

Fields,

[PowerAppMichael]

@Fields Will do, I've been so stumped on this I registered here to just grasp at straws. Not all with it on how the forum works.

Thanks!

[Fields]

Don't worry, i am new here as well :D, they ussually take a day or two max, to answer you!

Fields