User Profile
Hnin_Yu
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
can't attachment file sharepoint online in android mobile
Hello, I am facing the issue that can't attachment file in android mobile for sharepoint online mobile app. I can type other field but not click and not attach file with mobile. But in browser, it is working properly. How can I fix it ? Help me. My task item is over 5000. Thanks, Hnin Yu621Views0likes0CommentsPatch in save function of SharePoint Integration
Hello, I am facing some issues in power app in save function. I used customize form with power app in SharePoint online. In save function , I need to use Patch() instead of submitform(SharePointform1). Sometimes it is saved data and sometimes it is not. How can I do it? Please help me! What's wrong in it? I used the following code. If(SharePointForm1.Mode=New, (Patch('Details',Defaults('Details'),{'IGT Site Code':{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: DataCardValue163.Selected.Title},'Project Number':DataCardValue1.Text})), Patch(' Details',First(Filter('Details','Project Number'=DataCardValue1.Text)),{'IGT Site Code':{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: DataCardValue163.Selected.Title},'Project Number':DataCardValue1.Text}));SharePoint Online - Power Shell
Hello, I am trying to get items from SharePoint Online using Power Shell and want to insert to SQL server. I tried the following code and it is working. But I have a problem when I put that .ps file on Task Schedule. At that time, it is not working and not insert data in database table. If manual run , it is fine.How can I do it? $siteUrl = "https://-------------------"; $listName = "Test" $userName = "username"; $password = "password"; $SecurePassword = $password | ConvertTo-SecureString -AsPlainText -Force $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl) $credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userName, $SecurePassword) $context = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl) $context.Credentials = $credentials $Query= "<View Scope='All Items'> <Query> <OrderBy> <FieldRef Name='ID' Ascending='TRUE' /></OrderBy> </Query> <RowLimit>3000</RowLimit> </View>" $ListItems = Get-PnPListItem -List $listName -Query $Query $connection = New-Object System.Data.SqlClient.SqlConnection $connection.ConnectionString = "Server = ; Initial Catalog= ;Integrated Security=True" $connection.Open() $null="" ##Delete your command $SqlCmd = $connection.CreateCommand() $SqlCmd.CommandText = "delete from tbl_aa" $SqlCmd.ExecuteNonQuery() foreach($a in $ListItems) { $sqlVALID=$a['ID'] $sqlVAL1=$a['Title'] $SqlCmd = New-Object System.Data.SqlClient.SqlCommand($insert_stmt,$connection) $SqlCmd.Connection = $connection ## Create your command $SqlCmd = $connection.CreateCommand() $SqlCmd.CommandText = "INSERT INTO tbl_aa([Product ID],[Product Name]) VALUES ('$sqlVALID',NULLIF('$sqlVAL1',''))" $SqlCmd.ExecuteNonQuery() # } $connection.Close()884Views0likes0Comments
Groups
Recent Blog Articles
No content to show