I have a scenario where users will be assigned for each account I have to check how many accounts has been already assigned for each user because I have a list of users with max limit for each different user so based on the already assigned count I can do the remaining allocation to each user. Kindly suggest a solution for the same
Could you please share details regarding how are these allocations being done? what are you using? excel? some web platform?
Do you have a UiPath workflow built for this already or looking to built from scratch?
Hi @sonaliaggarwal47 ,
Am using excel in this process, I have mapping sheet with list of users & unknown number of accounts will be shared as inventory. Allocation will be done for each account based on some conditions I mean filtering the accounts but for each user there is limit can’t allocate more than that so need to check that limit has reached or not for an user before allocating
Are you able to show the format of your excel file? That way will be able to help you better.
However, if your excel file contains multiple rows for each user-account combination then you can use filter datatable activity to filter on based of user.
and then run a check on number of rows returned in filter datatable activity.
for eg dt_filter.rows.count> 15 (let say 15 as limit you want to specify)
then no further allocations, else allocate.