Unanswered

Outdated "Create a canvas app" tutorial with formula errors

(0) Share

Report

Posted on by lshelton

Greetings all,

I am new to PowerApps and trying to walk through this tutorial from Microsoft: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-scenario-build-app but I'm having lots of problems with the instructions not matching PowerApps despite being updated 6 months ago.

The main issue I'm running into right now is with Step 5: Build the ViewProjects screen. I'm trying to use the following formula on my gallery item:

SortByColumns(Filter('Project Details', StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

PowerApps is throwing errors about everything past 'Project Details' and Google has gotten me nowhere other than confirming that this formula should work. Have updates been made that mean this formula needs modification and if so, could I get some help with what needs modified?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 155,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @lshelton ,

The formula syntax is indeed valid.

SortByColumns( Filter( 'Project Details', StartsWith(Title, TextSearchBox1.Text) ), "Title", If( SortDescending1, Descending, Ascending ) )

I assume you have a Text Control on the screen called TextSearchBox1 ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
lshelton 9 on at

Like (0)

Report
Copy link

Link copied!

That's part of what's so confusing - I think just a ton has changed in the six months this was written in, because I've followed this step by step and even re-done some steps and none of them have had me create anything or created "TextSearchBox1" as a by-product even. The tutorial doesn't break down the syntax, as I had assumed it was searching fields in the SharePoint list I downloaded and recreated, which doesn't have that as a column either.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@lshelton

From what you are looking at - did you do all the steps in order?

In that tutorial, you specifically start with building the SharePoint lists. Then, in the Generate App step, this creates the app that you will then continue to work with. When you create that app, it will have all of the controls you are not finding (i.e. TextSearchBox1, etc.)

That is where they are created. You don't create them yourself when you generate an App from SharePoint like that.

I hope this is helpful for you.

Was this reply helpful? Yes No
lshelton 9 on at

Like (1)

Report
Copy link

Link copied!

That definitely wasn't made clear in the documentation, I will try backtracking and see how that goes. Thank you!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@lshelton

Yes, it's a little mysterious, but if you look at the top of the document you referenced, it mentions that the document is part of a series of tutorials and there is a link to the series overview.

Then the next key is to follow all of the "Next Steps" linked at the bottom of each article. That will get you through your journey.

Was this reply helpful? Yes No
lshelton 9 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
Well I had been optimistic, but it seems that this is just still an out of date tutorial. The two apps are separate and don't seem to read each other's fields, so the formula I mentioned still doesn't work when I go back through all the steps. Other things that seem to be outdated include no option to make a "Form screen", no default navigation buttons showing up, etc.

Was this reply helpful? Yes No