cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sr12
Helper III
Helper III

Refresh button

Hello everyone,

 

In reference to the attached picture, I want the refresh button to refresh the SharePoint list source which is called "leave request", and also to refresh the variables called "finalSick" and "finalVacation". I managed to let it refresh the source by using the code shown in the picture, but i couldnt let it refresh the variables as well.

I tried the following code: Refresh('Leave Request') & Refresh(finalSick), but an error pops up on the second part of the code.

 

So how can I do that?

sr12_1-1636523352893.png

 

Thanks in advance!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @sr12,

Have you solved your problem?

Do you want to clear the variables and refresh the Gallery items?

 

Please modify the formula as below:

Refresh([@'Leave Request']);
Set(
    finalSick,
    Blank()
);
Set(
    finalVacation,
    Blank()
)
Best Regards,
Qi

View solution in original post

3 REPLIES 3
PTBBSolutions
Solution Supplier
Solution Supplier

Hi @sr12 ,

 

What is you need of refreshing the SP list? In general there are very few used cases where you actually need it. You can't refresh a variable, you can set its value to something else - Set(finalSick, Blank());Set(finalVacation, Blank())

Ramole
Super User
Super User

Hi @sr12 

if you to reset the variable all you need is 

if it’s global Set(finalSick,blank) 

Or

local 

UpdateContext({finalSick:Blank()})

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.
v-qiaqi-msft
Community Support
Community Support

Hi @sr12,

Have you solved your problem?

Do you want to clear the variables and refresh the Gallery items?

 

Please modify the formula as below:

Refresh([@'Leave Request']);
Set(
    finalSick,
    Blank()
);
Set(
    finalVacation,
    Blank()
)
Best Regards,
Qi

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,647)