web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to make "with" com...
Power Apps
Unanswered

How to make "with" command run everytime?

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hello, I have this section of code in the "On Visible" Section of a screen which mainly displays available dates for a workspace. The issue I am having is that the "with" command doesn't seem to run when I select this screen since the dates fail to update. Help would be appreciated. Code is below:

 

ClearCollect('Bay Day','Workshop Planner');
Refresh(Queue);
ClearCollect(EarliestAval,Queue);
With({_items: Sort(EarliestAval, 'Date Out')},
Set(Date1, LookUp(_items, Title="1").'Date Out');
Set(DateRB, LookUp(_items, Title="Reference Bay").'Date Out');
Set(DateSL, LookUp(_items, Title = "Service Lane").'Date Out');
Set(Date2, LookUp(_items, Title = "2").'Date Out');
Set(Date3, LookUp(_items, Title = "3").'Date Out');
Set(Date4, LookUp(_items, Title = "4").'Date Out');
Set(Date5, LookUp(_items, Title = "5").'Date Out');
Set(Date6, LookUp(_items, Title = "6").'Date Out');
Set(Date7, LookUp(_items, Title = "7").'Date Out');
Set(Date8, LookUp(_items, Title = "8").'Date Out');
Set(Date9, LookUp(_items, Title = "9").'Date Out');
Set(Date10, LookUp(_items, Title = "10").'Date Out');
Set(Date11, LookUp(_items, Title = "11").'Date Out');
Set(Date12, LookUp(_items, Title = "12").'Date Out');
Set(Date13, LookUp(_items, Title = "13").'Date Out')
);
With({_items: Sort(EarliestAval, 'Date In')},
Set(Date1_0, LookUp(_items, Title="1").'Date In');
Set(DateRB_0, LookUp(_items, Title="Reference Bay").'Date In');
Set(DateSL_0, LookUp(_items, Title = "Service Lane").'Date In');
Set(Date2_0, LookUp(_items, Title = "2").'Date In');
Set(Date3_0, LookUp(_items, Title = "3").'Date In');
Set(Date4_0, LookUp(_items, Title = "4").'Date In');
Set(Date5_0, LookUp(_items, Title = "5").'Date In');
Set(Date6_0, LookUp(_items, Title = "6").'Date In');
Set(Date7_0, LookUp(_items, Title = "7").'Date In');
Set(Date8_0, LookUp(_items, Title = "8").'Date In');
Set(Date9_0, LookUp(_items, Title = "9").'Date In');
Set(Date10_0, LookUp(_items, Title = "10").'Date In');
Set(Date11_0, LookUp(_items, Title = "11").'Date In');
Set(Date12_0, LookUp(_items, Title = "12").'Date In');
Set(Date13_0, LookUp(_items, Title = "13").'Date In')
);
If(Date1 = Blank(), Set(Date1,First(Filter('Bay Day', Title = "1").field_2).field_2));
If(Date2 = Blank(), Set(Date2,First(Filter('Bay Day', Title = "2").field_2).field_2));
If(Date3 = Blank(), Set(Date3,First(Filter('Bay Day', Title = "3").field_2).field_2));
If(Date4 = Blank(), Set(Date4,First(Filter('Bay Day', Title = "4").field_2).field_2));
If(Date5 = Blank(), Set(Date5,First(Filter('Bay Day', Title = "5").field_2).field_2));
If(Date6 = Blank(), Set(Date6,First(Filter('Bay Day', Title = "6").field_2).field_2));
If(Date7 = Blank(), Set(Date7,First(Filter('Bay Day', Title = "7").field_2).field_2));
If(Date8 = Blank(), Set(Date8,First(Filter('Bay Day', Title = "8").field_2).field_2));
If(Date9 = Blank(), Set(Date9,First(Filter('Bay Day', Title = "9").field_2).field_2));
If(Date10 = Blank(), Set(Date10,First(Filter('Bay Day', Title = "10").field_2).field_2));
If(Date11 = Blank(), Set(Date11,First(Filter('Bay Day', Title = "11").field_2).field_2));
If(Date12 = Blank(), Set(Date12,First(Filter('Bay Day', Title = "12").field_2).field_2));
If(Date13 = Blank(), Set(Date13,First(Filter('Bay Day', Title = "13").field_2).field_2));
If(DateRB = Blank(), Set(DateRB,First(Filter('Bay Day', Title = "Reference Bay").field_2).field_2));
If(DateSL = Blank(), Set(DateSL,First(Filter('Bay Day', Title = "Service Lane").field_2).field_2));

Categories:
Building Power Apps
I have the same question (0)
  • RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Let's start with changing your formula to the following:

    ClearCollect('Bay Day','Workshop Planner');
Refresh(Queue);
ClearCollect(EarliestAval,Queue);

With({_items: Sort(EarliestAval, 'Date Out')},
 Set(Date1, Coalesce(LookUp(_items, Title="1").'Date Out', LookUp('Bay Day', Title="1", field_2)) );
 Set(DateRB, Coalesce(LookUp(_items, Title="Reference Bay").'Date Out', LookUp('Bay Day', Title="Reference Bay", field_2)) );
 Set(DateSL, Coalesce(LookUp(_items, Title = "Service Lane").'Date Out', LookUp('Bay Day', Title="Service Lane", field_2)) );
 Set(Date2, Coalesce(LookUp(_items, Title = "2").'Date Out', LookUp('Bay Day', Title="2", field_2)) );
 Set(Date3, Coalesce(LookUp(_items, Title = "3").'Date Out', LookUp('Bay Day', Title="3", field_2)) );
 Set(Date4, Coalesce(LookUp(_items, Title = "4").'Date Out', LookUp('Bay Day', Title="4", field_2)) );
 Set(Date5, Coalesce(LookUp(_items, Title = "5").'Date Out', LookUp('Bay Day', Title="5", field_2)) );
 Set(Date6, Coalesce(LookUp(_items, Title = "6").'Date Out', LookUp('Bay Day', Title="6", field_2)) );
 Set(Date7, Coalesce(LookUp(_items, Title = "7").'Date Out', LookUp('Bay Day', Title="7", field_2)) );
 Set(Date8, Coalesce(LookUp(_items, Title = "8").'Date Out', LookUp('Bay Day', Title="8", field_2)) );
 Set(Date9, Coalesce(LookUp(_items, Title = "9").'Date Out', LookUp('Bay Day', Title="9", field_2)) );
 Set(Date10, Coalesce(LookUp(_items, Title = "10").'Date Out', LookUp('Bay Day', Title="10", field_2)) );
 Set(Date11, Coalesce(LookUp(_items, Title = "11").'Date Out', LookUp('Bay Day', Title="11", field_2)) );
 Set(Date12, Coalesce(LookUp(_items, Title = "12").'Date Out', LookUp('Bay Day', Title="12", field_2)) );
 Set(Date13, Coalesce(LookUp(_items, Title = "13").'Date Out', LookUp('Bay Day', Title="13", field_2)) );
);

With({_items: Sort(EarliestAval, 'Date In')},
 Set(Date1_0, LookUp(_items, Title="1").'Date In');
 Set(DateRB_0, LookUp(_items, Title="Reference Bay").'Date In');
 Set(DateSL_0, LookUp(_items, Title = "Service Lane").'Date In');
 Set(Date2_0, LookUp(_items, Title = "2").'Date In');
 Set(Date3_0, LookUp(_items, Title = "3").'Date In');
 Set(Date4_0, LookUp(_items, Title = "4").'Date In');
 Set(Date5_0, LookUp(_items, Title = "5").'Date In');
 Set(Date6_0, LookUp(_items, Title = "6").'Date In');
 Set(Date7_0, LookUp(_items, Title = "7").'Date In');
 Set(Date8_0, LookUp(_items, Title = "8").'Date In');
 Set(Date9_0, LookUp(_items, Title = "9").'Date In');
 Set(Date10_0, LookUp(_items, Title = "10").'Date In');
 Set(Date11_0, LookUp(_items, Title = "11").'Date In');
 Set(Date12_0, LookUp(_items, Title = "12").'Date In');
 Set(Date13_0, LookUp(_items, Title = "13").'Date In')
);

     

    If that does not get you what you need, then please site an example of one of the variables that is not set and what you have in your datasource that should correspond to it.

     

    I hope this is helpful for you.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Currently Date1 is set to 3/11/2022, however in the updated list, the value is now 3/22/2022. Hopefully this is what you are asking for

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Currently Date1 is set to 3/11/2022, however in the updated list, the value is now 3/22/2022. Hopefully this is what you are asking for

  • RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @Anonymous 

    What do you mean by "the updated list"?  We are working with the values of the variables - correct?  That was what you originally posted in your question - or are you stating some other problem?

    Do the variables get the values you expect?

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    So I have this flow which automatically replaces certain value in a list value based on the date. So if the "Date Out" column in SharePoint List Item "1" is 3/22/2022, the automated flow replaces all relevant column values with a list item in another SharePoint List which has a "Date In" value that is the same day as the "Date Out" column value that occupied that list item originally. However the Date1 and Date1_0 Values (for example), don't automatically update when I select the diagram which shows the dates available on the screen. Currently Date1 and Date1_0 are displaying date values from the SharePoint list item that previously occupied that spot. Hopefully that helps.

  • RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Ah...so your original post heading makes a little more sense now - I think!

    You mentioned you wanted this formula to run every time, but that it doesn't seem to.

    If I am thinking what I am hearing now is correct, you are stating that the variables are not getting updated when you perform your flow action.

    If that is all the case, then yes, this is true, variables will not update until they are updated in a formula.  Since you have this in the OnVisible, it will only occur when the screen becomes visible.

     

    Let me know if I am tracking what the issues is that you are having.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans