cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter user and count number of days applied and update a column

Hi Scott, @ScottShearer , I have a leave management SharePoint list and want to count the number of leaves applied by a user from beginning to till date so that the annual allotted leave will be deducted from YTD leave and balance is shown in another column. I want flow to filter or look for user who has submitted the leave and count and give the total of the other column where number of days leave will be there pertaining to this user. The number of days leave is a calculated column which is result of End date minus Start date.

Please help in filtering or queering the submitter name and count the number days applied by the person.

12 REPLIES 12

Hi,

 

Would you want a flow that triggers every time a new entry is added on an SPO list?

What you're asking seems possible, but I need more information here. You can always get the user who submitted the entry, and filter records based on User Email = Email that submitted the entry. But please provice more details here if possible!

Thanks in advance.

Anonymous
Not applicable

Hi,

Thank you for the response, let me explain the requirement in details. 1. Users A, B, C, D will be submitting request for leave in using the form connected to SharePoint List 2. The SharePoint list will have columns like start date, end date and no of days leave applied, in this start and end date columns are date columns and no of days column is calculated field which will calculate the no of days (end date minus start date) and put the result 3. I want an action in the flow when A submits a leave request, look for A’s other leave entries (which is nothing but filtering all the leave entries of A) and then look for corresponding entries of A’s no of days leaves applied column, sum of all leave would then to be updated to a column YTD leave Hope this clarifies

Hi,

 

I guess something like this would work for you:

 

edguerre_0-1594368897989.png

 

 

The flow triggers when a new item is submitted. After this, you get all items submitted by that user email, by filtering.

Then you initialize an empty variable and add an apply to each where, for each item retrieved from the list, it will get the Total Leave Days from that item and add it to the variable. After the loop ends, you should have the total of days, and then you can update the item you with with that info.

 

Hope this helps!

Anonymous
Not applicable

Hi, Thanks for the quick respsonse, i have tried to get info as per the screenshot but the flow ended with error in the action apply to each,

Could you please tell me

1. What items to be selected in the apply to each

2. What needs to be selected as Value field under action Increment variable LeaveRequestQuerry3.jpg

Anonymous
Not applicable

Hi,

I am getting the below error, as the column that flow counts in not an integer, as mentioned to you the No of days column is a calculated column  (leave end date - leave start date) LeaveRequestQuerry4.jpgwith property as Number.

@Anonymous 

 

1- When you put your mouse over 'value', it must come from the Get items connector.

2- Change the value to a string, as the values coming from the calculated field aren't integers. Should work like that.

Anonymous
Not applicable

Hi,

Thanks for the response, i tried by changing to String but still it is not working. Attached is the error screenshot.FlowError.jpg

@Anonymous 

 

Can you go to the Sharepoint list, look at that column and confirm what type of variable it contains? It needs to be integer on the flow and integer on Sharepoint!

Anonymous
Not applicable

Hi,

The type of the column is number and it is the column which is a calculated column with the result of other 2 columns (leave end date minus (-) leave start date.FlowError2.jpg

@Anonymous Change it to Single line of text please, and keep the flow with the variable as a string.

Anonymous
Not applicable

Hi,

It's still not working even after changing the column to single line of text, now the error is different as below

 

The inputs of workflow run action 'Increment_variable_2' of type 'IncrementVariable' are not valid. The specified variable 'Total Leave Days' of type 'String' is not supported. The supported variable types are 'Integer, Float'.

This is pretty strange. As a last test, I would change the column to Number, the variable to Float on the flow and try again. There is a mismatch of variable types here.

If this does not resolve your issue, I recommend to open a support ticket with Microsoft - I believe this would be quickly resolved over a call.

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (2,666)