Unanswered

SharePoint List not keeping value

(0) Share

Report

Posted on by Cesc

Hi guys

I have this app that submits as completed "Yes" into a SharePoint List when I hit the submit button. Now what happens is it submits the value to the SharePoint list as "Yes", and within aa few seconds, that same value in the SharePoint list disappears. I honestly can't figure out why this happens. The Column type in the SharePoint list is a "Yes/No" column.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Have you verified the record does update to yes/no on sharepoint, and then disappears? Like placing one browser with the list open, and submitting the update from a mobile device or a adjacent browser so you can watch the item appear and disappear?

If so, do you receive any errors at all?

Is there any possibility early in the process your app collects the sharepoint list, then updates it from your control. And then afterwards at some point sends original collected info back into sharepoint, overwriting your changes?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Cesc,

Could you please share a bit more about the scenario, is it empty in the "Yes/No" column or something like false or a tick instead?

Do you want to patch a text value to a Yes/No column in the SP list?

From your description, you want to patch a text value to a boolean column. I think there is no way to achieve this currently within PowerApps.

I am confused that why there appears a "Yes" for seconds in your scenario, please just show me your current "Yes/No" column and check if there is nothing within or not.

Regards,

Qi

Was this reply helpful? Yes No
Aki78 39 on at

Like
a
(0)

Report
Copy link

Link copied!

You probably know this but "Yes" is true, and "No" is false, so if you're patching to the list you need to use the true/false values.

Definitely need more information though:-
1. What control is being used in the app? Toggle/Checkbox etc...
2. Default of the Sharepoint Column is it Yes or No?
3. Are you using a form to submit back to the list? Is the Submit button using the SubmitForm() function.
4. Does the item actually write to the list and then dissappear? or does it just dissappear from the form?

Was this reply helpful? Yes No