User Profile
bbliang
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Different Template IDs when using Export-PnPListToSiteTemplate to export the same lists
I use Export-PnPListToSiteTemplate to export lists of a sharepoint oneline site to a template. I would like to put the list template exported to git repository for version control in Azure DevOps pipeline. But I find that the pipeline commits and pushes to git repo every time even though there is no any change to the lists. I checked the commit history and found that the template ID has been changed. Is it possible to keep the template ID unchanged? The intent is not to commit to git if there is no any change to the list.Use PnP Powershell to export and import list template but prompt column doesn't not exist
I am writing pnp powershell in Azure DevOps pipeline to run Export-PnPListToSiteTemplate to export a list to template, and ran Invoke-PnPSiteTemplate to import it to another site. It prompted error message that the column referenced by the formula doesn't exist. I checked the xml file exported, a calculated field's formula refererences another calculated field which was next to it in the xml file. It may be the reason. <Field Type="Calculated" DisplayName="Collected / Written Off" EnforceUniqueValues="FALSE" Indexed="FALSE" Format="DateOnly" LCID="1033" ResultType="Text" ReadOnly="TRUE" ID="{0c8a6740-fa5c-4cb8-9491-f3bddb013f2b}" SourceID="{{listid:LegalCaseRecord}}" StaticName="CollectedOrWrittenOff" Name="CollectedOrWrittenOff" ColName="sql_variant2" RowOrdinal="0" CustomFormatter="" Required="FALSE" Version="3" IMEMode="inactive"> <Formula>=IF(AND([Active / Completed]="Active",[Amount Collected]>0,[Amount Written Off]>0),"Collected",IF(AND([Active / Completed]="Completed",[Amount Collected]=0,[Amount Written Off]>0),"Written Off",""))</Formula> </Field> <Field Type="Calculated" DisplayName="Active / Completed" EnforceUniqueValues="FALSE" Indexed="FALSE" Format="DateOnly" LCID="1033" ResultType="Text" ReadOnly="TRUE" ID="{0f88a515-5561-468c-a6cc-5f637e314f9e}" SourceID="{{listid:LegalCaseRecord}}" StaticName="ActiveOrCompleted" Name="ActiveOrCompleted" ColName="sql_variant3" RowOrdinal="0" CustomFormatter="" Required="FALSE" Version="7" IMEMode="inactive"> <Formula>=IF([CaseCompletedFileClose]=FALSE,[ActiveOrCompletedValue],"Completed")</Formula> </Field> <Field ClientSideComponentId="00000000-0000-0000-0000-000000000000" CommaSeparator="TRUE" DisplayName="Amount Written Off" Format="HK$123,456.00 (Hong Kong S.A.R.)" LCID="3076" Name="AmountWrittenOff" Title="Amount Written Off" Type="Currency" ID="{0c664d3a-22d9-471d-aaf4-e927bcf76fbd}" Version="18" StaticName="AmountWrittenOff" SourceID="{{listid:LegalCaseRecord}}" ColName="float9" RowOrdinal="0" CustomFormatter="" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="FALSE" IMEMode="inactive"> <ClientValidationFormula>=if([$ActiveOrCompletedValue]=='Completed','true','false')</ClientValidationFormula> <Default>0</Default> </Field> The PnP Powershell module version I used is 1.12.0 Is there any idea how to fix this issue? Manually updating the xml file exported is not practical as it is in the pipeline.Import Power Apps Solution in Parallel to Different Environments Failed
We have a release pipeline with 2 stages in parallel, Validation and Test. The tasks in these 2 stages are the same: import powerapps solution to the environment and apply upgrade, but they are using different service connections to the target environments. We set up self-hosted agent pool and install agents on the same local server. When the pipeline was ran last night, Validation stage is using agent02, while Test stage is using agent01. The weird thing is the Test stage imported the solution to Validation environment althought the log showed that the command was to connect to Test environment at first, but then showed connecting the validation environment. As a result, Test stage import the solution to Validation environment, and the Validation stage failed because there already there is a upgrade solution imported by the Test stage. Why did this happened? The 2 agents should be connected to different environment, why the Test stage connected to Validation environment wrongly?How to grant Service Principle access right to Azure Repos
In Azure Pipelines, we need to get source code of another organization's Azure Repos. Currently we use personal access token, but it links to a user who might leave the organization. Can we use a service principle to authenticate? How to grant the service principle access right to the other organization's Azure Repos?
