Forum Discussion
Power Automate List Formatting - Compact List Rows
I have found a solution!
If you're using a "Send an HTTP request to SharePoint" action to apply custom JSON view formatting to a list view, your request body looks something like this:{ '__metadata': { 'type': 'SP.View' }, 'CustomFormatter': '@{outputs('Compose')}' }To also set the view to Compact List density, add the ViewType2 property with a value of COMPACTLIST:
{ '__metadata': { 'type': 'SP.View' }, 'CustomFormatter': '@{outputs('Compose')}', 'ViewType2': 'COMPACTLIST' }Because both properties live on the same SP.View object, this single call applies your custom formatting and sets compact row height at once
I'm not sure I'm understanding. You shouldn't need to create a list view and you definitely don't need to control the row height. SharePoint does all of that automagically.
- Create your list. Set up your views and your preferred formatting using the native UI.
- Use the default SharePoint form. You can customize the heck out if it to decide what fields show up in what order, whether they are hidden and only appear under a condition, etc. With a little JSON you can even get creative with colors and formatting.
- Open the New Item form and use "Copy Link" to get the link to the new form. You can paste/distribute that however you like.
- Add your Power Automate workflows to generate notifications, fill in field values, etc. - whatever you want. If you use "When an item is created" as your trigger, the flow will run only on new items. Or you can have it run every time an item is created or edited. You can use trigger conditions to control when it runs, say when your item is edited and the status changes to "completed" or whatever. Remember that Power Automate will run under YOUR credentials, so it might be best to get a service account to ensure that the process is independent of your existence in that company.
Hello!
Yes sir I am aware about those functionalities, we're having a misunderstanding - I spoke too quick.
Currently I have a SharePoint Site Page; and within, there's a list visible with a button present to add a new item to this list.
Once a list item's submitted, a power automate flow triggers with the same trigger you've mentioned "When an item is created".
This flow:
1. Updates the trigger item
2. Send Email Messages
3. Creates a view that's filtered to hold this item, that's been added from the form, so when users go through the list view on the site page, they'll see a view available for this item.
I have no issue creating the view, or modifying the view filters.
My issue's that I cannot find a way to set the view formatting, on power automate, to have the row's heights to be "Compact list".
This is a fine detail thing to do on a list view automation, but's relevant considering how many rows will live per page.
Thank you for reading and I appreciate any further assistance!
I have found a solution!
If you're using a "Send an HTTP request to SharePoint" action to apply custom JSON view formatting to a list view, your request body looks something like this:{ '__metadata': { 'type': 'SP.View' }, 'CustomFormatter': '@{outputs('Compose')}' }To also set the view to Compact List density, add the ViewType2 property with a value of COMPACTLIST:
{ '__metadata': { 'type': 'SP.View' }, 'CustomFormatter': '@{outputs('Compose')}', 'ViewType2': 'COMPACTLIST' }Because both properties live on the same SP.View object, this single call applies your custom formatting and sets compact row height at once