Hi guys,
I am in the process of building an app that connects and adds data to a sharepoint list like so:
Patch(FrokostBestilling_1;Defaults(FrokostBestilling_1);{Titel:"Frokost";Dato:DatePicker1.SelectedDate;Medarbejdernr:TextInput1.Text;Initialer:TextInput2.Text & Navigate(Screen2;ScreenTransition.CoverRight)})
Now it works really well, it insert the data to the sharepoint list, and navigates to the next screen, however in the last section befor the navigation the "initialer" it now adds "true" to the end of it(See attached picture), my guess is that it is of course returning "true" because the navigation happens, however is there a way to ensure that it does not add it to the sharepoint list.
If i remove the "&" operator, it gives me an "error" with the syntax and says that it contains invalid arguments and wrong "symbols", anyone got any suggestions or solutions 🙂
- Toby
Solved! Go to Solution.
You are headed in the right direction, but I think you are using the wrong seperator. Since I see ';' used where I would normally insert ',' in the rest of your function I assume you are in a locale where the use changes. Take a look at this paragraph from the documentation.
Some separators and operators will shift based on the decimal separator of the author's language:
Author's language decimal separator | PowerApps decimal separator | PowerApps list separator | PowerApps chaining operator |
---|---|---|---|
. (dot or period) | . (dot or period) | , (comma) | ; (semi-colon) |
, (comma) | , (comma) | ; (semi-colon) | ;; (double semi-colon) |
I think the formula you actually need is.
Patch(FrokostBestilling_1;Defaults(FrokostBestilling_1);{Titel:"Frokost";Dato: DatePicker1.SelectedDate;Medarbejdernr:TextInput1.Text;Initialer:TextInput2.Text});;Navigate(Screen2;ScreenTransition.CoverRight)
Hey @Anonymous
Yeah, this is what i thought as well, however when i update the expression to
Patch(FrokostBestilling_1;Defaults(FrokostBestilling_1);{Titel:"Frokost";Dato: DatePicker1.SelectedDate;Medarbejdernr:TextInput1.Text;Initialer:TextInput2.Text});Navigate(Screen2;ScreenTransition.CoverRight)
It underlines the semicolon ( ; ) after curlyclose and parenclose at the end, and says that it is an unextected symbol error?
And i've tried with other symbols just to be on the safe side, but that is the same issue 🙂
You are headed in the right direction, but I think you are using the wrong seperator. Since I see ';' used where I would normally insert ',' in the rest of your function I assume you are in a locale where the use changes. Take a look at this paragraph from the documentation.
Some separators and operators will shift based on the decimal separator of the author's language:
Author's language decimal separator | PowerApps decimal separator | PowerApps list separator | PowerApps chaining operator |
---|---|---|---|
. (dot or period) | . (dot or period) | , (comma) | ; (semi-colon) |
, (comma) | , (comma) | ; (semi-colon) | ;; (double semi-colon) |
I think the formula you actually need is.
Patch(FrokostBestilling_1;Defaults(FrokostBestilling_1);{Titel:"Frokost";Dato: DatePicker1.SelectedDate;Medarbejdernr:TextInput1.Text;Initialer:TextInput2.Text});;Navigate(Screen2;ScreenTransition.CoverRight)
Yes of course! Perfect, worked like a charm! thanks very much 🙂
User | Count |
---|---|
195 | |
125 | |
88 | |
48 | |
42 |
User | Count |
---|---|
280 | |
164 | |
138 | |
81 | |
76 |