Power Automate - Multiple SharePoint Lists and Report
HTML-код
- Опубликовано: 6 фев 2023
- This video explains how to get latest record details from multiple SharePoint lists.
Expressions I used in this video are:
Split SP List names
split(outputs('SharePoint_List_names'),',')
SP List Name
item()
Details
{
"List Name": @{outputs('SP_List_Name')},
"Title": @{outputs('Get_items')?['body/value']?[0]?['Title']},
"Created": @{formatDateTime(outputs('Get_items')?['body/value']?[0]?['Created'],'dd-MM-yyyy')},
"Created by": @{outputs('Get_items')?['body/value']?[0]?['Author']?['DisplayName']}
}
Thanks, abm this is super work 👍🙏🙏
Thanks a lot
Hi abm, thanks so much for the tutorial. Any idea how I could link to each item?
Thanks ABM, This was very useful. I hope you can help me with a little bit of formatting the data created in the HTML table. Similar to your work, I have two SPO lists on the same site, and I am getting the most recent items (one row from each with all the columns, all will be different information) , and making two HTML tables to send them in an e-mail. I need to make two different tables (see below) and also I need the table headers vertical, any advice is appreciated. Thanks!!
Table 1 (from list 1)
Service 1 Status OK
Service 2 Staus Error
Service 3 Status OK
Table 2 (from list 2)
Service x Status OK
Service Y status OK
Service Z Status Error
Hi
Thanks for your question. So for vertical headers you need to format custom HTML table. Here is a good article describing the technique.
ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/
Thanks
hey abm.. How do you handle it when One sharepoint list doesn't have a new record as it's a possibility? In my scenario I have 2 sharepoint Lists instead of 11 and there are instances when either one of them may not have a new record recreated at the same time. ie. List 1 had a new record and List 2 doesn't have a new record or vice versa and there is an instance when both lists will have a new record.
Hi
Thanks so much for the support.
I was away for few weeks. Do you still need help in this please?
Thanks
@abm - can you create a video on how to create a flow which would update the columns of one sharepoint list based on different list ?
Hi
So you want to update another list? Any specific column types such as multi-select, datetime? Explain in an example. I will try my best.
Thanks
thanks ABM!
Can you also pls make a video on how can I update the columns (created date, description, created by) of an item in sharepoint based from the published article from a confluence page.
For example, my colleague published an article in Confluence with a specific reference ID and then from our team's Sharepoint site, I'll create an item (with 5 columns- Reference ID, Created date, description, created by and URL). Enter the ID of the item under the reference ID fiels and the confluence URL under the URL field then save it. Right click the item and trigger an instant flow to automatically update the 3 remaining columns. Thank you
Hi
Never worked with confluence integration. So when you say publish means is that happens in a SharePoint list?
Thanks
@@abm4975 My colleague will published the article/report in confluence for wider audience then I need to create a sharepoint list /item in out team's sharepoint site for our own record.
Is this a third party product? Please have a look at API. If you have any documentation related to this I will have a look.
Thanks
Hello abm, I am trying to append multiple sharepoints lists. Is there a way to edit this JSON: "outputs('Get_items')?['body/value']?[0]?['Title']" to output all the items in the 'Title' column into different rows? Thank you!
Hi
Could you post this in Power Automate community forum. Tag me as @abm. I will have a look.
powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks
@@abm4975 I figured it out. It was actually quite simple and I was overcomplicating it. I got the Outputs from the Create CSV table actions and put them into the Attachment Content in the Send an email (V2) action. Thanks anyway!
Fantastic. Thanks a lot for letting me know.
Hi the 'created by you' I think is a single text, I want to display name of created by for Person or Group. Please let me know how can I do.
Hi Shiva
Thanks for the question. Have a look at this thread from Power Automate community.
powerusers.microsoft.com/t5/Building-Flows/Power-automate-to-get-displayname-and-email-in-person-or-group/td-p/1185632
If you need further help please let me know.
Thanks
Figured out to to do this from multiple (3) site collections but it only shows me 1 item from each site collection list. Where I need to show all items based on the get items filter query. Only shows the first item.
Sorry I couldn't understand in detail. Could you contact me via teams. Have a look on my channel about section for connecting via email. I could look into this via a screenshare.
Hi! Facing the same issue...did you manage to solve it and add all the rows in the dataset? Thanks in advance.
Is there a way to order by created day?
Hi
You mean created date? Yes you can. Try the below under the Order by
Created asc
Hi Mate, is there any quicker way to extract data from multiple share point lists with about 140 columns and save it on the share point as a csv.
Hi
All these multiple lists are related?
@@abm4975 yes, various from different SharePoints
If its different columns then its going to be tricky. Is that all different column names or similar column names in all lists?
@@abm4975 No. all columns are the same
My understanding is you have different lists and 140 columns. That's kind of similar I explained in my video. Where do you need assistance? If you on teams please connect me via teams. Check my channel about section. I could do a screenshare.
Thanks
I have my SharePoint lists set up as a 1 to Many relationship. I'd like to send an email to the 1 depending on a date on the many.
Hi
Could you please provide me an example of your data?
Thanks
@@abm4975 Thank you for responding. I figured it out. The trick was using a Select to Merge the lists and map them out.
@@elbaz4 Can you elaborate a little more , how to use select to merge 2 lists? I have similar situation and I am stuck. I have actually 3 sharepoint lists to merge with a one to many relationship between 1 to 2 and 2 to 3.
Hi
I need to see the SharePoint list and your flow. I could offer a screenshare. Check my channel about section and connect me via Teams.
Thanks
I watched until about the 6:00 mark. My goal is to delete all items from 70+ lists. Will this work???