Hi there,
My flow so far is as follows:
Created Form from Excel Online
Once it's filled in, it will send out a notification via email with all the details needed.
I need to add an operation where it will count the number of times the input has been added.
e.g.
Each time 'Mike' is entered, the value on the right column will increase by 1.
At the moment I can't do this as Excel doesn't allow formulas with Flow.
Is there a way I can do this with Data Operations?
Flow
Solved! Go to Solution.
Hi @ms1994 ,
You could refer to the following method to configure Flow.
Expression reference:
length(body('List_rows_present_in_a_table')?['value'])
add(length(body('List_rows_present_in_a_table')?['value']),1)
Image reference:
Hope it helps.
Best Regards,
Hi @ms1994
Please see the screenshots below:
I initialised an empty integer variable and set that to the value from the get row action (I used the expression because the value in my excel is stored as text)
int(body('Get_a_row')?['Column2'])
Then I am incrementing that value by 1 and updating teh row. I am identifying the row by the response from the form.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @ms1994 ,
You could refer to the following method to configure Flow.
Expression reference:
length(body('List_rows_present_in_a_table')?['value'])
add(length(body('List_rows_present_in_a_table')?['value']),1)
Image reference:
Hope it helps.
Best Regards,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
89 | |
56 | |
39 | |
38 | |
35 |
User | Count |
---|---|
79 | |
66 | |
57 | |
52 | |
42 |