User Profile
Mike_Honey
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Forms Pro to Power BI via Common Data Service - can only see users own Surveys?
I've successfully connected Forms Pro through to Power BI via the Common Data Service, by following the steps described here (they are a little out-of-date): https://powerapps.microsoft.com/en-us/blog/cds-for-apps-powerbi/ But after reviewing the data pulled from entities likemsfp_survey,it seems I can only retrieve Forms Pro data for the user who is signed in (to the Power BI CDS connection)? I was expecting/hoping to get the data for all the surveys that have been shared for editing. BTW it seems others are seeing the same issue wrt: https://community.powerbi.com/t5/Desktop/Power-BI-CDS-Different-Data-for-Different-Users-on-a-Shared-MS/m-p/8109761.9KViews0likes1CommentRe: Sharepoint Online, number column NOT aligned right
Sinan621- my tests so far are regular number columns, so it can work. Sorry it didn't work for you. .displayValue is mentioned on this page: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting If I find out more I'll post back here.18KViews1like2CommentsRe: Sharepoint Online, number column NOT aligned right
Sinan621- I've stumbled across a cleaner solution to keep the thousands formatting (or any other formatting you have set) - just add .displayValue after@currentField. That returns a formatted string, using the columns format settings. For example: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "style": { "display": "table", "width": "100%" }, "children": [ { "elmType": "div", "txtContent": "@currentField.displayValue", "style": { "display": "table-cell", "text-align": "right", "vertical-align": "middle" } } ] }18KViews3likes4Comments