It should. Since you’d be returning the metadata from the library, it’s just a variation on the API used.

@@TimDobrinskiPowerAppsandCoffee I've tried, but can´t construct the columns needed, for example the 'Full Path', the 'Folder PAth' for subfolders, file name with extension or File Name, Im using your same ParseJson example. but is only working for the title, any suggestions would be appreciated.

You can. ForAll(colListOfRecords As DatedItem, If(DatedItem.StartDate >= Today(), Collect(colNewCollection,DatedItem) ) )

Thanks, but what I meant it let's say I have a record with a start date of 01/01/23 and an end date of 03/01/2023 (UK format), then is there a way to loop through and get the start, each date in between and the end date and paste them into a collection with the same title/other info, and do that for multiple records each with a start and end date?

@@n2datasolutions443 Yes... You can use the DateDiff and Sequence Functions in the main ForAll. See Below. ForAll( colDatedData As Dateitem, // Original Records with StartDate and EndDate ForAll( // Iterate through days 0->TotalDays Sequence(DateDiff(Dateitem.StartDate,Dateitem.EndDate,TimeUnit.Days),0,1) As InterimDays, Collect( colInterimData, { RecordID: Dateitem.ID, // Individual Dates are Original StartDate + InterimDate, starting at 0 RecordDate: DateAdd(Dateitem.StartDate,InterimDays.Value,TimeUnit.Days) } ) ) )

Right now, no. They took away the ability to call controls on other screens. 😞

@@TimDobrinskiPowerAppsandCoffee Ah, would've helped me a lot right now 🥲

What exactly would you like recommendations on? Details of setting it up or a specific issue?

@@TimDobrinskiPowerAppsandCoffee I want to continuously edit my canvas app straight from source code VS Code then commit, not downloading, then importing all the time, is that possible? With or without DevOps?

That’s a fascinating idea. Thank would it would be possible if you were comfortable with editing the files in the repository. Let me tinker with this. I honestly never thought about it before.

Interesting question. I used 5000 as a random number - never thinking about pulling items beyond the list view threshold. What i’d think of trying is to two-step it with two pulls from SharePoint get items using a skip-5000 in the second. Id have to try that.

@@TimDobrinskiPowerAppsandCoffee Thanks for the quick reply! I thought about the "get first 5k, cache last Id, start again at last Id" method, like back in the days when we all first tried to get above the 2k limit. But it's not a fun method...

I’m seeing it more. For example, moving D365 records to Dataverse, I have to do it in loops of 5000-7500 to avoid timeout.

You made me curious. Turns out, it was pretty simple. Thank you!!

To be honest, I’ve wondered if it’s possible. Flow can collect it. The only fear would be timing out on really large sets.

Reverting would be done by setting up a pipeline to use a previous version.

The events list won’t be different from the generic list, just change the columns used in the example to point to the columns in the events list. The calendar here just needs the start and end dates to work.

Are you preforming a commit to the repo?

I am having the same problem @Tim Dobrinski. I am also getting an additional error in the Command Line Script step. I have done everything exactly the way you did it but it fails every time. Please advise.

First, is the “Allow scripts to access the OAuth token” setting checked on the Agent Job? Second, did you establish the initial folder in the repo?

You may be able to use the IN command in the filter. You may hit a delegation warning but it may work. Trying to filter with an IN against the DISTINCT values from the table. It’s very similar to SQL.

The 2k limit is a problem, i agree. Only thoughts I have are to either prefilter if possible or… and this is new for me but I’ve had good luck, try Dataverse. The speed I’ve seen with DV might be enough to let you work on the list directly.

You can get around the 2k limit by building a collection, which can hold more than 2000. I've built a collection with over 30,000 items in it by loading multiple collection in the App Onstart in 2000 increments. So if you had a data source with 20,000 items, you have 10 collections, each with 2000 item in it. Then the you just make a collection that merges all these into one. The biggest hurdle is finding a value you can use to break the data into groups of 2000 records/list items each. DON'T use the ID. If you don't have another column then you can use then create another column called IDCopy (NOT CALCULATED) and then use a Power Automate to populate it with the value in the ID every time a record is added. If you have another field that you can group things into less than 2000, without getting duplicate, you can avoid the IDCopy, but in my case I didn't have a field to do this with. This is the code I used to do this. I hope it is helpful even though this is many months after this video and this question was posted. Concurrent( ClearCollect(colChargeMaster1, Filter('Invision.vChargeMaster',IDCopy <2000)), ClearCollect(colChargeMaster2, Filter('Invision.vChargeMaster',IDCopy >= 2000 And IDCopy < 4000 )); ClearCollect(colChargeMaster3, Filter('Invision.vChargeMaster',IDCopy >=4000 And IDCopy <6000 )), ClearCollect(colChargeMaster4, Filter('Invision.vChargeMaster',IDCopy >=6000 And IDCopy <8000 )), ClearCollect(colChargeMaster5, Filter('Invision.vChargeMaster',IDCopy >=8000 And IDCopy <10000 )), ClearCollect(colChargeMaster6, Filter('Invision.vChargeMaster',IDCopy >=10000 And IDCopy <12000 )), ClearCollect(colChargeMaster7, Filter('Invision.vChargeMaster',IDCopy >=12000 And IDCopy <14000 )), ClearCollect(colChargeMaster8, Filter('Invision.vChargeMaster',IDCopy >=14000 And IDCopy <16000 )), ClearCollect(colChargeMaster9, Filter('Invision.vChargeMaster',IDCopy >=16000 And IDCopy <18000 )), ClearCollect(colChargeMaster10, Filter('Invision.vChargeMaster',IDCopy >=18000 And IDCopy <20000 )), ClearCollect(colChargeMaster11, Filter('Invision.vChargeMaster',IDCopy >=20000 And IDCopy <22000 )), ClearCollect(colChargeMaster12, Filter('Invision.vChargeMaster',IDCopy >=22000 And IDCopy <24000 )), ClearCollect(colChargeMaster13, Filter('Invision.vChargeMaster',IDCopy >=24000 And IDCopy <26000 )), ClearCollect(colChargeMaster14, Filter('Invision.vChargeMaster',IDCopy >=26000 And IDCopy <28000 )), ClearCollect(colChargeMaster15, Filter('Invision.vChargeMaster',IDCopy >=28000 And IDCopy <30000 )), ClearCollect(colChargeMaster16, Filter('Invision.vChargeMaster',IDCopy >=30000 And IDCopy <32000 )), ClearCollect(colChargeMaster17, Filter('Invision.vChargeMaster',IDCopy >=32000 And IDCopy <34000 )), ClearCollect(colChargeMaster18, Filter('Invision.vChargeMaster',IDCopy >=34000 And IDCopy <36000 )), ClearCollect(colChargeMaster19, Filter('Invision.vChargeMaster',IDCopy >=36000 And IDCopy <38000 )), ClearCollect(colChargeMaster20, Filter('Invision.vChargeMaster',IDCopy >=38000 And IDCopy <40000 )) ); ClearCollect(colChargeMasterALL,colChargeMaster1,colChargeMaster2,colChargeMaster3,colChargeMaster4,colChargeMaster5,colChargeMaster6,colChargeMaster7,colChargeMaster8,colChargeMaster9,colChargeMaster10,colChargeMaster11,colChargeMaster12,colChargeMaster13,colChargeMaster14,colChargeMaster15,colChargeMaster16,colChargeMaster17,colChargeMaster18,colChargeMaster19,colChargeMaster20);

The Powershell action can call a file. You could have a set of Powershell scripts in the the repo and have them callable based on a variable?

@@TimDobrinskiPowerAppsandCoffee hey thanks so much. I think I found another source that said that the tools can’t support it right now and that the service accounts won’t be able to bypass the authentication needs. So right now at least I think we still have to run the script everytime we push updates. Thanks for the reply though! Real hard to find information this topic and you nailed it!

Probably not as the items themselves will be setup on a grid and not freely centered. I will tinker some and see.

Dataverse tables aren’t yet setup for CICD. They promise it but it’s not yet implemented.

@@TimDobrinskiPowerAppsandCoffee Thanks for answer Tim.. Do you use export and import tools to control it or any other solution?

As of right now, no. I’m starting to transition to dataverse and am hoping for (if not tools) something in PowerShell.

Can you give the full Set statement? I’m wondering if you aren’t closing the record.

@@TimDobrinskiPowerAppsandCoffee I fixed the issue thank you very much for the response. I had my client on a different language so the operations where kinda different.

#in vscode: pac solution create-settings --solution-zip Variables_1_0_0_6.zip ____________________________________ #in powershell: Install-Module -Name Microsoft. PowerApps.Administration.PowerShell -Force Install-MOdule -Name AzureAD -Force $password = "ThislsWhereYourPasswordGoes" $cred = New-Object System.Management.Automation.PSCredential ($user, (ConvertTo-SecureString $password -ASPIainText -Force)) $envGuid = "" $appName = "EP13-EnvironmentVariables" $apps = Get-AdminPowerApp -EnvironmentName $envGuid I Where-Object { $=DisplayName -eq $appName } $apps | Select-Object AppName, DisplayName, EnvironmentName, LastM0difiedTime | Sort-Object LastModifiedTime Connect-AzureAD -Credential $cred $newOwnerEmail = "TheNewOwnerEmailAddresq" $userID = Get-AzureADUser -Objectld $newOwnerEmail Set-AdminPowerAppOwner -AppName $apps[0].AppName -AppOwner $userID.Objectld -EnvironmentName $envGuid

If you wanted changes in code for each stage, maybe. What I would think would work would be (given a DEV-TEST-PROD series): have a pipeline to take from dev to test. Leave both solutions as Unmanaged. Then have another pipeline take it from test to prod. This way, the unmanaged app in test will be editable. In prod, should you choose, you can import as manager to freeze the code.

Are you using variables? Are they added correctly to any string?

@@TimDobrinskiPowerAppsandCoffee I'm using one variable, SolutionName, with all text in value, scoped to the "Push to Stage" piece of the release pipeline. I'm using it on my Pack Solution task on line Solution Output File: $(Build.StagingDirectory)/$(SolutionName).zip and again on the Import Solution on line Solution Input File: $(Build.StagingDirectory)/$(SolutionName).zip

@@TimDobrinskiPowerAppsandCoffee I updated and removed the use of the variable. Instead, i wrote out the raw name of the zip file. I also made another change yesterday(refreshed the AAD app registration in the environment. maybe other changes I can't recall right now). Now getting another error: "Message: Solution manifest import: FAILURE: The following solution cannot be imported: Cr43e0d. Some dependencies are missing. The missing dependencies are :" . The error is longer and lists the dependencies like bots and connections. Now when i navigate into the environment, it shows the solution, but its empty.

Missing dependencies are usually fixed in the solution itself. For every item in your solution, click the properties and select add required components (or something close to that). It will add items to your solution that existing components need. Try that and re-run the pipeline.

Thank you for the question. As of right now, SharePoint Online is the only CICD-ready environment variables data source. Dataverse is “coming soon” but it is not known when (at least not to me).

??

Is the folder in your Azure DevOps repository populated with the solution files?