set a column value on sharepoint list to default with a button on power apps

[Amsha5]

Hello There, 

Is there any way to set a column value on sharepoint list to default with a button on power apps ? 

the column changes between 1 to 7 and i need a reset button to send the values on the column to 1 !!

[Nogueira1306]

Hey! Explain your question better....

You want to set a default on a SP List?

[JR-BejeweledOne]

I am going to presume that you are already working with this SharePoint list in your power app.   Your question reads like you want to set all the values in that column back to 1 at the same time,  would this be correct?

[PG_WorXz10]

Hi @Amsha5 ,

If you want to send the value from PowerApps to SharePoint list column value than its possible but if you want to change default value of the sharepoint list from PowerApps its not possible. 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Amsha5]

@Nogueira1306 

I have a column on SPO. What i need is a reset button on my power app that sends the values on the column to 1 whenever i press the button !!

[JR-BejeweledOne]

I understood that part.   Are you wanting to reset the value for all items in the SharePoint list or for a single item when you press the button?

[Amsha5]

@JR-BejeweledOne I need it for all items on the column 

[Amsha5]

@PG_WorXz10  Yes i want to send the value from power apps to share point list 🙂

[JR-BejeweledOne · Accepted solution]

You can do it like this:   If your clickCount column is text, please wrap the 1 in quotes "1"

UpdateIf(SharePointList, clickCount <> 1, {clickCount: 1})

[PG_WorXz10]

Hi @Amsha5 ,

Please use the below code if it helps. 

on button select: Set(varDefaultValue,true);Set(varValue,1);

On Patch clickCount: if(varDefaultValue,varValue,YourNormalValue);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.