13
Hi, I have created a flow through which I am getting a output in HTML table on my email. I would like to add 1 other column to that HTML table wherein I would to see numbers in series. I have tried using initialize variable and increment variable but not able to get expected result. I am getting (1,1) in Sr No column response but it should be (1,2,3, etc). Attaching the response of my flow.
So I need to help in order to achieve my goal for my flow.
Thanks in advance.
Hi @IAK,
Just to let you know, you could do this with a select - potentially 1 select but I will show you with 2. First you have your get items, then the select with the specified columns, then the final select can use range on the length of the array to addproperty like so:
This uses the following:
From: range(0,length(body('Select')))
From: range(0,length(outputs('Get_items')?['body/value']))
Hi @IAK
For making the sr no column at first, what you have to do is you can change the column order while creating HTML table itself , see below for a simple example:
I have intialized a simple array like this
Array
Share
Report
All responses (
Answers (
[{"A":1,
"B":12,
"C":13},
{"A":10,"B":20,"C":30}
]
Now i want B as first column , then A and then C as column order, for that I have used following syntax while creating HTML table within HTML table action.
See i have selected columns field as Custom and manually entered the column order as B,A,C with its field values as item()?['B'] , item()?['A'], item()?['C'] respectively.
So output looks like
Hope the above information helps while building the flow !
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
@Nived_Nambiar Thank you so much for you quick reply with solutions, Appreciate your efforts.
Hi @IAK
Sorry i have missed the point of adding select action. for that you have to add select action right after get items and then use the output of select action in apply to each instead of value dynamic content, That's all you have to do !
see below flow for reference !
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Hi @Nived_Nambiar , Thanks for the quick solution to my query. Appreciate a lot, I understood your explanation.
Just one doubt, As I need 4 columns in my final email output (below is the attached image)
So to have these columns, I need to use select function at any point right?
Where I can use that?
Hi @IAK
using select action won't help you as it would be appending same values again and again.
Another approach to do this would be like below
step1: initialize two variables, one array variables which stores final array which needs to be converted to table and SrNo which stores the index which needs to be added on column SrNo.
Step2: Use Get items to get items from sharepoint
Step 3: Use Apply to each to loop through each items of get items action
Steps to be done in loop are described below
Step 3.1: use compose action which helps to add srNo property to the element currently on which iteration is done like below
Expression: addProperty(items('Apply_to_each'),'Sr No',variables('SrNo'))
3.2: Add the output of compose action to FinalTable array using append to array action
3.3. As shown above, use increment variable to increase the value of SrNo variable.
Outside of loop , use create html table action to convert FinalTable array to html table format like below
Hope this helps !
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Hi @IAK
Could you share how flow looks like ?
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
