Hello all,
I have a dates sharepoint list with a column of count. Based on another list, where items get created i want to create a flow that updates my dates list count column based on the date the item was created.
Example: a item gets created for date 4/8/2019. A flow should trigger to see a item was created and then update the dates list for column date count
4/8/2019 1
and if another one gets created on same date count goes to 2.
Thank you all !
Hi @mmattar,
I'm not exactly sure where your question is in this post, it seems like you have set it up nicely already. If you are asking what the flow should look like I'll try to help.
Here's some screen shots on how I would do it.
When SharePoint Item Created
Apply to Each
Hope that helps,
Piper
Edit: Corrected Apply to Each image
@Piper What if the item being counted is a choice field?
I'm trying to do the very same flow, but I need to allocate the count to the specific column, based on the choice.
To give some context, we are recruiting candidates for a job. For each candidate, we need to record the source of how we recruited them (radio, newspaper, job board, etc). There are about twenty different options and we want to count how many come from each source.
I tried working through your excellent instructions, but from this, I'm guessing I either need to set up a sharepoint list for each source, or a flow for each source.
@Anonymous
The complexity depends on what the list you are updating looks like. The example the original poster gave was a rows of dates with a count column.
Is yours rows of sources with a count column (narrow and deep) or is it a single row with 20 source count columns (wide and not deep)?
With that information I can better suggest a solution.
Thanks,
Piper
@Piper It is wide and not deep? lol...
I have one row for each date and 20 source count columns. I would provide a screen shot but I cannot even get it all in the frame to capture it.
@Anonymous did you find a way for counting based on choice? Kindly share your approach if you did. I am stuck on a similar requirement.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
25 | |
24 | |
23 | |
23 | |
19 |
User | Count |
---|---|
58 | |
40 | |
40 | |
29 | |
24 |