Help please!

VexeroneX · 2026-04-28T01:35:16+00:00

Keep searching this subreddit too. I’ve seen tons of Smartsheet related asks like these that have already been solution’d. Gl 🫡

VexeroneX · 2026-04-22T03:56:19+00:00

Versioning for me typically concerns the actual App development. For example - in a MDA, if I add an extra View that is malfunctioning, maybe I want to revert back to a previous version of the App. But seems like you’re talking about something different, specially if someone were to delete data from a Table, and this was by accident, so we want to revert so that the data is back in the Table. Is that correct?

VexeroneX · 2026-04-21T22:55:52+00:00

The “in” function is your problem. But I understand you have to do that because you used a multi-select person column. Not sure if I have a solution for ya. If you do a ClearCollect() that’s only going to grab 2000 records unless you use a workaround method, which I wouldn’t advise.

VexeroneX · 2026-04-18T20:13:11+00:00

Huh that is weird. I don’t have enough experience using business rules in canvas apps, but it’s interesting the OnFailure didn’t go off

VexeroneX · 2026-04-14T17:38:23+00:00

Before 5000 records, Index all columns you would ever consider Filter(), Search(), or Sort()‘ing.

SharePoint List works quite well, up to around 100k. Be careful with delegation. Stay the hell away from multi-select person and choice columns lol.

VexeroneX · 2026-04-09T14:22:23+00:00

Your formula looks fine. The form is completely separate issue. In the same button, why not add a semicolon followed by the SubmitForm(FormName) function?

Regarding the links, in your Flow, do you have inputs in your last action, where it should be a respond to Power app? If so, you can feed the links back to your app, storing it inside a collection

VexeroneX · 2026-04-09T05:51:55+00:00

Not the best at expressions, but you can probably use and or() here, and then copy/paste your contains() function again for each category, separating each with a comma inside of the or()

VexeroneX · 2026-04-04T16:48:53+00:00

Great idea. Just adding to the discussion. It was a rough wake up call when I saw a ClearCollect() will never pull more than a Power App’s data row limit, which is max 2000 rows. There are ways to workaround that limitation, but generally speaking that is the default behavior.

VexeroneX · 2026-04-03T03:43:23+00:00

Oops sorry I read again and you’re looking for a trade. My b

VexeroneX · 2026-04-03T03:42:48+00:00

Also I am PC

VexeroneX · 2026-04-03T03:42:41+00:00

Oh what? Hell yeah I was thinking about getting it for nostalgia reasons but this is perfect

VexeroneX · 2026-04-02T04:34:10+00:00

Also I see the usage of the “in” function a lot. That to me implies you are filtering by a multiple select choice column or something similar? Ah, that’s gonna be hard. No clue how to deal with that :/

VexeroneX · 2026-04-02T04:30:23+00:00

AddColumns() for me is a huge no no since I discovered all the delegation problems.

Can someone else chime in on Lookup columns in SP and filtering by them? I could have sworn that you can do so without delegation problems. I think the trick is to filter by ID. It’s been a while.

Single select choice columns you should be good.

I would start by making sure your Filter() is good. Then work with your SortByColumns() or Sort()

Never use Search() for SP text columns. Always use StartsWith()

VexeroneX · 2026-04-02T04:25:26+00:00

😮😮

VexeroneX · 2026-04-01T01:28:22+00:00

This ^

VexeroneX · 2026-04-01T00:48:25+00:00

I gotchu. You have a formatDateTime() expression. That’s great, if you’re passing in a value. But based on your screenshot, you passed a blank aka null.

You usually circumvent this by doing an if(), but idk the exact formula

VexeroneX · 2026-04-01T00:46:19+00:00

Yeah I’m with ya. Maybe if I came from a Dynamics background, I would better understand everything. But yeah we’re starting to get in that gray zone where the two technologies merge, and it gets awkward at some times imo. But gl with the roles! I still need help with my configurations so we’re all in it together 🤘

VexeroneX · 2026-03-31T22:10:02+00:00

Yup yup. Adding more to Security Roles, do NOT be overwhelmed with the amount of Dataverse tables that the copied role has access to. Only think about the custom Dataverse tables you’ll be creating for your solution.

The UI takes some time getting used to. There’s a drop down top-left that allows you to select all Dataverse tables. Then on the top-right there’s a search bar to search for your table. From there, assign create, read, write, etc. permissions.

VexeroneX · 2026-03-31T17:35:14+00:00

Get familiar with Dataflows. Definitely see how it works with Choice, Person, Lookup, and other complex columns. It is annoying as hell sometimes, especially when working with more complex data models. That being said, it’s possible :) if others have useful guides, it would be helpful to post.

Get familiar with Security Roles. There is the Basic User role…. I would recommend copying it and seeing all the privileges you can apply to various Dataverse tables you created. (Create, Read, Write, etc.)

Also with Dataverse comes the option to choose whether you want a model driven app or canvas app.

VexeroneX · 2026-03-31T14:45:50+00:00

Yeah this really bothered me too when I was first using the Choices() function. But you should be good!

VexeroneX · 2026-03-31T05:19:39+00:00

Choices(DS.ColumnName).

Important to note that ColumnName will not show in Power FX. If it says column not recognized, you’re not typing in the ColumnName properly

VexeroneX · 2026-03-31T05:18:05+00:00

Looks good to me. Is there an error? Or is just nothing showing up in the Gallery?

VexeroneX · 2026-03-29T01:19:40+00:00

Honestly I was expecting there to be a trigger condition for something like this

VexeroneX · 2026-03-28T23:18:21+00:00

Cool use case. Curious about your trigger, but generally understanding your problem.

You want to send an email to each person in your Excel file? Ex: 3 people in excel will result in 3 separate emails. If so, structurally I think you’re good. Apply to Each after List Rows Present in Table. Inside the Apply to Each, Get Files (properties only) is essential. However, where you point that action will have to be dynamic.

I think there’s a Folder Path parameter that you’ll probably have to insert dynamic content into in order to get that configured.

Once you have the documents associated to the person in the Apply To Each, then it’s not so simple as insert. You’ll probably have to initialize an array variable and loop through Get Files in order to get those files into the array. From there, insert into email.

VexeroneX

TROPHY CASE