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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sign ups only for blan...
Power Apps
Unanswered

Sign ups only for blank dates in a list

(0) ShareShare
ReportReport
Posted on by 45

I am making a PowerApp for people who are signing up to be on-call for particular weeks in a year. The data is stored in a Sharepoint list with the columns "First Responder" and "Week Commencing", where "Week Commencing" has the Monday that their on call week starts. How can I make it so only the blank Mondays in the list are available to be signed up for? I don't want it to be possible for people to sign up for a week that is already full. 

 

 

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @leyburn19 , can you help?

  • leyburn19 Profile Picture
    2,157 on at

    Some questions:

     

    1. data Type for Monday Column?

    2. How do you do you determine a list is "Full". 

    3. Is there a criteria (calculation)? Are the two lists,  one for reponders and one for days?

     

    Can you give me some more info on structure please.  I do a lot of filtering that shows only available things to be booked>  EG Onky vehicles not booked can be booked.  Only Desks/Rooms not booked can be booked etc

  • sec4zj Profile Picture
    45 on at

    1. It's a date type

    2. If there is name in the First Responder column (otherwise it is blank)

    3. It's one list - it looks like the attached (blue is where the name would be)

     
     

     

    list structure.JPG
  • leyburn19 Profile Picture
    2,157 on at

    Ok, I think I understand.  You have a list that is constant.  It has a record for every monday and you want to selectthose mondays without a responder.  Is that correct?

     

    I would do a something that collects all blank row on start up:  EG:

     

    ClearCollect(MyCollection(Filter(Source,Responder=Blank()))

     

    Then create a Gallery based on the collection with the result showing that dates available.  In the gallery I would put a simple textbox for the responder to put their name in.  I would also add a save icon to the row.  The save icon Visbile property to be If(!isBlabnk(textinput),true,false)  The Onselect property put Patch(source,Lookup(Source,ID=ThisItem.ID),{Responder:TextInput?.Text})


     

    This would 

    1. Show only available dates
    2. Save only appear when a name is entered
    3. Update the record

     

  • sec4zj Profile Picture
    45 on at

    When I try to do this ClearCollect function, I get an "invalid number of arguments" error. 

     

     

  • leyburn19 Profile Picture
    2,157 on at

    Its missing a comma, sorry

    Try

    ClearCollect(MyCollection,(Filter(Source,Responder=Blank()))

  • sec4zj Profile Picture
    45 on at

    Got it - the formula works now. How do you create a gallery based on a collection? 

  • leyburn19 Profile Picture
    2,157 on at

    You use the collection the same as you do a data source. In the items property put the collection. 

     

    Now the fun begins.  the Collection is in memory so  when using it you need to think that it is not connected to the data source.  You need to patch the results.

     

    In the Gallery I would put the date using the date supplied by the collection plus a textinput that the default is based on the Respnder column.  This will be blank until someone puts data in it.  Now add a save icon to the same row.  On the visibile property to the icon have it set to: If(!isblank(textinput?), false, true)   This will mean that if some types something in that box,  the icone will appear.  On the Onselect to the icon have

     

    Patch(datasource,Lookup(source,ID=Thisitem.ID),{ResponderColumn:Textinput?.Text})  - This will put the text into the datacource row.  then I would add another line to the Onselect to run your Collection again and the Gallery will refresh with one less record.  Hopw this all makes sense 

  • sec4zj Profile Picture
    45 on at

    When I try to make a collection based off of the MyCollection I created, it is just blank. How do I get it to actually populate with the dates that have no first responder? 

  • leyburn19 Profile Picture
    2,157 on at

    Can you tell me how many records you have that should be in the Collection?  I assume you have  a list that is a fixed number of rows

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

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 July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard