Поиск по сайту Power Apps
Поиск
Re: Updating the records in dataverse custom table if there is a duplicate
I have made a flow and that takes 5 mins to run with just 38 rows in dataverse and with 38 duplicates. It will take a lot of time if the data is more than 5000 because it needs looping. So, I'm...
Re: Layering 2 sets of postcodes ArcGIS POWERBI
hi @v-yalanwu-msft this is the data but there are 1300 hotels and 600 stores. We want to plot the store in an ArcGIS map then add the hotels on top and show how many hotels near s...
Filtering Choices function
Hi, I have a combo box, where I have in the items the following: choices(PK_Antragx.ALT_Positionx) That works fine and gives me a list of all professions. Now I want to fil...
Canvas App - Fetch list of dataverse tables
Is there any way to fetch all the list of dataverse tables and display them in canvas app be it list/dropdown control
Re: Filtering Choices function
HI @andiart , Try using below formula - Filter(Choices(PK_Antragx.ALT_Positionx); "Assistent" in Value)
Re: Power apps form to Powerpoint Presentation
Thanks, That's what i did in the end, all other options were either not available or pricey.
Choices column not showing from lookup table
I have two tables Element & "CE Plans" Table Element has Name (text), Number (wholenumber), Owner (lookup), UID (autonumber) and Email(text) columns. Table "CE Plans" has a column...
Re: Row Level Security on Power Apps issue
@Gerard14 , Not the best column type to use with large data sets (I do not use them at all), but in this case, the below should work Filter( 'UKI - Accounts List' , 'Access Email'.Emai...
Re: Row Level Security on Power Apps issue
@WarrenBelz Its a person or group type field in SharePoint. This is the message I get
Re: Display full large image from gallery both in web as well as mobile device
Hi @DirkKoch , If they are images, you can view attachment thumbnails in a gallery on both browser and mobile devices with ThisItem.Value The code you have posted from my blog r...
Re: User() Function and Lookup to Users table
Thanks for the tips and explanation, very good info sir!
Re: Using StartsWith to perform filtering of 2 single line of text columns in gallery - 1 results in delegation warning, the other doesn't - Why??
Hi @TrayH , I see that now, it was just an obvious reason why you would get that error. I have parsed the below with some bracketing and also used Len() which covers both IsBlank and IsEm...
Updating the records in dataverse custom table if there is a duplicate
Hello guys, I have a table in dataverse and it is populated using power automate and I also have this unique ID column. What I want to do is that if there is a new data coming from the power automat...
Re: Choices function can't show more than 20 values
Hi @pjonkers , Sorry, I should have noticed this detail sooner. You should rename your flow. Best Regards, Dezhi
Re: Formular not updating the right Customer
Hi @Yancho Is it a similar problem on another screen or the same place? Thanks, Stalin (Microsoft MVP) Blog - Learn To Illuminate Blog YouTube - Learn To Illumina...
Re: View data sources of a Power App
Thanks @AaronKnox, that seems so close! But, the data tab is not available here, just As I said, this was developed by someone else and I am trying to learn by reverse-engineering. Apolog...
Re: View data sources of a Power App
Hi @PAppyDevoDev , Form1 has a property called DataSource. This should reference the SharePoint list.: Further, you can click the Data icon, and then next to the DataS...
Re: Row Level Security on Power Apps issue
Hi @Gerard14 , At last I think the proper reason has emerged - is that a multi-select person field ? If so, you need a different filter and it will never be Delegable.
Re: Select earliest and latest dates between two columns that have the same ID in another column.
@laganlee You can use this, paste this complete code in the Advanced Editor: let Source = Table.FromRows ( Json.Document ( Binary.Decompress ( ...
Re: Expression.Error: 1 arguments were passed to a function which expects between 2 and 3. Details:
Thanks Antriksh this seems to have worked !
Combine Search, Filter and Lookup in canvas?
Trying to get my gallery to search with multiple tables. Having a heck of a time here. Perfect world I would want to have one search box to filter the products using info from 2 tables. But I couldn'...
Re: IsBlank(), IsEmpty(), or = " " ?
IsBlank will work if you convert it to text to check. So it would be: IsBlank(inputvalue.Text) I normally do something like > 0 to check for number input instead but depends on the circum...
Re: Using StartsWith to perform filtering of 2 single line of text columns in gallery - 1 results in delegation warning, the other doesn't - Why??
Hi Warren, it is in fact a single line of text. If you look at my post again there are 2 images on it. The 2nd shows that Assigned To is single line of text. This was done because originally this was...
Re: Limit User Access Form Entry
@RJF61 Create two forms, one for capturing new information that has more limited cards and another for editing existing information that has all the cards. Use different buttons to open...
Re: Gallery border doesn't change when parent.error is not blank
You rock! the problem was the borderthickness, I added a condition there If(IsBlank(Parent.Error), 0, 2) an worked as well. Thank you so much!
