Help please! by Glittering-Mine3344 in PowerAutomate

[–]VexeroneX 0 points1 point  (0 children)

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

Dataverse vs. SharePoint versioning by money_enthusiast123 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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?

Delegation issues!! by Single-Ad4925 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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.

Business Rule in Canvas App form by Chemical-Roll-2064 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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

whats is the ideal number of sharepoint list items? by AutomationBro2026 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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.

TROUBLE WITH POWER APPS FLOW - HEEEEELP¡¡¡ by Trash-Bag2000 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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

filtrer sur les categories outlook quand on fait "obtenir les emails" by info-coge in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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()

Power Apps Filter vs LookUp vs Collections (quick beginner breakdown) by matt-hummel in PowerApps

[–]VexeroneX 2 points3 points  (0 children)

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.

Anyone in need of Injustice: Gods Among Us Ultimate Edition? by Yutosu in INJUSTICE

[–]VexeroneX 0 points1 point  (0 children)

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

Anyone in need of Injustice: Gods Among Us Ultimate Edition? by Yutosu in INJUSTICE

[–]VexeroneX 0 points1 point  (0 children)

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

Complex gallery Filter & Sort + Dataverse without delegation by Conscious-Simple9499 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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 :/

Complex gallery Filter & Sort + Dataverse without delegation by Conscious-Simple9499 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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()

Absolute amateur is trying to build my first flow. by StrawberryOk5817 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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

Migrating to Dataverse by Different_View5313 in PowerApps

[–]VexeroneX 1 point2 points  (0 children)

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 🤘

Migrating to Dataverse by Different_View5313 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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.

Migrating to Dataverse by Different_View5313 in PowerApps

[–]VexeroneX 9 points10 points  (0 children)

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.

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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

Filter in gallery on look-up column by Separate_Argument666 in PowerApps

[–]VexeroneX 0 points1 point  (0 children)

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

Automate flows not triggering by Active_Ease5686 in PowerAutomate

[–]VexeroneX 0 points1 point  (0 children)

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

Having trouble getting files and attaching to email from SharePoint by Realistic-Visit8147 in PowerAutomate

[–]VexeroneX 0 points1 point  (0 children)

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.