Fetch Data from on premise Database, SAP HANA Cloud for SPFx adaptive card Extension
I am trying to achieve. looking for how to retrieve and store data on a database system deployed on-premise, such as an SAP HANA solution that has its own database through the custom Viva Connections ACE(Adaptive Card Extension) card which I am trying to create. To give you an idea an example a customer has a locally deployed payroll Management solution that uses a local database. I am trying to connect the ACE card to that database to display the payroll information for an Employee in the card which will be added to the Viva connections Dashboard inside Microsoft Teams.
To get values from multiline text to checkbox
Hello Everyone, I have an Problem to get the Checkbox value in edit mode to reading value to checkbox I will Explain the scenario. i have created the the web part in that web part we get the checkbox value from different list dynamically when i checked the check box value to added in SharePoint list in multi line of text comma separately added successfully. now, I want to added value of multi line of text value came into the check boxes in checked form but issue i s facing in that to get check box value hoe can i get the multi line of text value in checkbox to get the value from SharePoint multi line text value how can i get the value in SharePoint list
SharePoint custom theme toggles to a default Blue after a published site page refresh.
I have created a SharePoint subsite and applied a custom theme to it. The page looks good until I publish it. After it is published, once I refresh the page, it quickly toggles to a default blue theme. The theme was created using the custom PowerShell script as below, $themepalette = @{ "themePrimary" = "#e81a2b"; "themeLighterAlt" = "#fef5f6"; "themeLighter" = "#fbd8db"; "themeLight" = "#f8b6bb"; "themeTertiary" = "#f1707b"; "themeSecondary" = "#eb3342"; "themeDarkAlt" = "#d11726"; "themeDark" = "#b01320"; "themeDarker" = "#820e18"; "neutralLighterAlt" = "#f8f8f8"; "neutralLighter" = "#f4f4f4"; "neutralLight" = "#eaeaea"; "neutralQuaternaryAlt" = "#dadada"; "neutralQuaternary" = "#d0d0d0"; "neutralTertiaryAlt" = "#c8c8c8"; "neutralTertiary" = "#595959"; "neutralSecondary" = "#373737"; "neutralPrimaryAlt" = "#2f2f2f"; "neutralPrimary" = "#000000"; "neutralDark" = "#151515"; "black" = "#0b0b0b"; "white" = "#ffffff"; } Add-SPOTheme -Identity "ThemeName" -Palette $themepalette -IsInverted $false
Conditional Formatting
Conditional Formatting So I am building a dynamic Teams List form and I am doing conditional formatting I want certain fields to appear based on conditions, and that works however when I go into the list complete the pending actions and I choose the item I want the details pane returns the following error: As you can see the list has the information, so I am not sure what I need to do. If I remove the conditional formatting from the 2 columns, the app works as expected, so I know it has to be something in the formatting that I am doing wrong. In addition when I select a record and hit edit, it Labels: Developer Microsoft Teams Add tags 187 Views 1 Like 11 Replies Reply Skip to sidebar content All Discussions Previous Discussion Next Discussion 11 Replies Meghana-MSFT replied to Chrisfoster1330 Jul 19 2021 06:46 AM @Chrisfoster1330 It seems like there is an issue with the JSON file. Could you please https://jsonlint.com/. Also it could be great if you could share your JSON file with dummy data and conditions used so that it could be helpful for us to look into the issue. Please make sure you have removed any PII. Mark as best response 0 Likes Reply Chrisfoster1330 replied to Meghana-MSFT Jul 20 2021 10:18 AM So I am using simple formulas in column formatting and not really using JSON the formula for "Agent" is =if([$Category] == 'Agent', 'true', 'false') and JSON validator says the =if is wrong and it states it should be without the = but it is not a valid formula. Mark as best response 0 Likes Reply Meghana-MSFT replied to Chrisfoster1330 Jul 22 2021 02:32 AM @Chrisfoster1330 From the formula it seems like you are using Sharepoint list. Could you please let us know if it is the correct assumption? Also Please take a look at the https://support.office.com/en-US/client/results?Shownav=true&lcid=1033&ns=SPOStandard&version=16&omkt=en-US&ver=16&HelpId=WSSEndUser_FormulaSyntaxError. If you could guide us on the resource where you are using the formula, it will be great for us to try in the right direction. Mark as best response 0 Likes Reply Chrisfoster1330 replied to Meghana-MSFT Jul 22 2021 05:20 AM @Meghana-MSFT Yes you are correct it is in a SharePoint List, And I am using it in a column called "Agent" and a column called "Team Meeting" and it is pointed at a column called "Category". So if the Category is "Agent" then only that field will be visible and likewise with the one for "Team". This function is working, however I am getting an error, when I am trying to view the record in the "Details Pane" and also none of the record is visible when you click on edit. My formulas appear to be correct and like I said previously when I remove the formulas the form works as expected. Here are the formulas again: =if([$Category] == 'Agent', 'true', 'false') And =if([$Category] == 'Team', 'true', 'false') Mark as best response 0 Likes Reply Meghana-MSFT replied to Chrisfoster1330 Jul 29 2021 10:42 PM @Chrisfoster1330 We tried to repro this at our end and we did not face any issue with view the record in the "Details Pane" and edit options. Could you please try the same thing in Sharepoint list and do the same operations? And see if you are still facing the issue? Mark as best response 0 Likes Reply Chrisfoster1330 replied to Meghana-MSFT Jul 30 2021 04:56 AM I have deleted and rebuilt this app 4 times all with the same result. I have built other apps with the same conditional formatting and it works just fine with no issues, but try as I might I cannot get this one to work period. I have no idea where to go next Mark as best response 0 Likes Reply Meghana-MSFT replied to Chrisfoster1330 Jul 30 2021 05:16 AM Could you please try the same thing in Sharepoint list instead of Teams lists and do the same operations? And see if you are still facing the issue? Mark as best response 0 Likes Reply Chrisfoster1330 replied to Meghana-MSFT Jul 30 2021 06:08 AM So you are asking me to create it in SP and not Teams? Can I copy it over or do I have to build it in SP? Mark as best response 0 Likes Reply Meghana-MSFT replied to Chrisfoster1330 Jul 30 2021 06:27 AM @Chrisfoster1330 There is an option to open the list in Sharepoint. Attaching a screenshot for your reference. Mark as best response 0 Likes Reply Chrisfoster1330 replied to Meghana-MSFT Jul 30 2021 06:44 AM I have done this and I get the same issues. What is my next step, I really have to get this thing fixed. As I stated I have tried everything I know to get this to respond to no avail. Mark as best response 0 Likes Reply Meghana-MSFT replied to Chrisfoster1330 Aug 01 2021 10:47 PM - edited Aug 02 2021 12:34 AM @Chrisfoster1330 , This does not seem like a teams issue. Could you please raise this on Sharepoint Lists platform. Mark as best responseImport SharePoint Online list data to On premise SQL server database using SSIS
Hello Community, I am trying to import SharePoint online list data to SQL server using SSIS. I have connected this using O Data Source Editor. I can see all the columns except the choice type columns in SSIS destination mapping. Is there any different approach to do this ? Any help is greatly appreciated! Thank you
SharePoint Online .WSP file to use at "root" site level
I created a template from an existing site in our SharePoint Online and saved in our Solutions Gallery under that site collection which is what is expected. How can I use that same template I have just created but not as a subsite (when using New -> Subsite) of that site collection it was created from and use that same template in our "root" /sites locations? For example, we have built a nice SP site under oursite.sharepoint.com/sites/projectoffice and saved it as "projectofficetemplate".wsp. Its now under the oursite.sharepoint.com/sites/projectoffice Solutions Gallery as expected. We can now use this template under the projectoffice site collection as a subsite and it is now available for us to choose. Can I download this "projectofficetemplate".wsp file and "upload it" to the /sites location so that when I say Create new site, it would be available there? For example, I want to create another site collection called "oursite.sharepoint.com/sites/AnotherDept" but I want to use the template or "projectofficetemplate".wsp file created FROM oursite.sharepoint.com/sites/projectoffice to create the new "AnotherDept" site collection? I uploaded it to the root site and activated it but when I go and select create new and selected the solutions gallery, I uploaded and activated but yet, it does not let me choose that nor have that option and the site is just a plain team site, not using the .WSP file I just uploaded and activated. it just shows it as "select template later" in classic view... so I selected it but the template I want to use is not working or taking effect. How can I do that or is that possible? Thank you!
