Power Apps-Suche
Suche
Re: Incompatible types for comparison: Filtering gallery using a Combo box
Hi @thatakke, Skills.Value is a table right? (a multi-select choice column called "Skills"), which means you need something like: Index(SkillsBox.SelectedItems,1).Value in Skills...
Re: Preview different document types that are stored in Azure Blob
Hi @Julien2, The examples you gave are from a SharePoint Library (which comes with a Thumbnail property that Azure Blob does not provide AFAIK). In the following article t...
Re: Incompatible types for comparison: Filtering gallery using a Combo box
Replace in all your code SkillsBox.SelectedItems by the code that follows : SkillsBox.Selected.value
Re: How to count total number of users in office 365 connector using PowerApps
@Sa7 Put the code inside the text property of your label CountRows(Office365Users.SearchUser({top: 999}))
Re: Error Extraxt after delimiter if contains _ or return same value
Hi @RajivRavichand , the reason for this error message lies in the underscore. This represents a record in that environment. Did you mean to put a reference to a column there instead (lik...
Re: Problem with 1:n relationship
Yup, I have encountered this with SQL Server, two values 'Contoso' and 'Contoso ' are considered the same in SQL Server, but Power Query doesn't considers this so it shows both Contoso in...
Re: Export Excel from a gallery
@Scott_Parker thank you for your reply; So there is no other solution apart from the scroll so that all the lines appear. And for the order of the lines Whare I can modify them please.
Re: Patching Collection Item with Form.Updates
Hi @Frank89 Just to be sure I have all the information: the datasource of the form has the same logic as the initialisation of the collection on the OnStart? Are there any other ...
Re: Can't patch more than two data sources with if function
Use the Monitor function in Power Apps, then press the button, look at the log in Monitor to see what the issue is, I suspect the later patches are throwing errors but you're not seeing them. ...
Rename columns referencing column number rather than column name
How can I rename columns of a table when I do not know upfront what the column names of the table are? So effectively I would like to reference the columns by index rather than by name. Inp...
DateAdd adding wrong number of hours on the day of time change
Does DateAdd try to take into account DST somehow? Today is 11/6/2022 and the day of time change. I am in Eastern time, so we switched from UTC-04:00 to UTC-05:00 this morning. If I...
Re: What is meant by 'an instance of a database'?
Every Dataverse instance is tied to a single environment. If you have two Davaverse instances, then you will have two environments. Here is a link that gives a description of the main pages in the Po...
Re: DateAdd adding wrong number of hours on the day of time change
Are you supplying the chosen date in the timezoneOffset() funtion as an argument? That's how TimeZoneOffset calculates the appropriate offset for the DST setting for that day. For the spe...
Re: Best way to archive/export the stale in dataverse?
@ChrisPiasecki for the first time backup we might export around 7 tables (8 GB of data) and after that i would say daily basis we might export 50-100 records(table rows). is power automate is go...
Re: Problem with OnUnCheck property of my checkbox
@roby9390 . Please take notice of what @Drrickryp and @Akser are telling you here. There is no advantage in collecting only one column - the whole record is actually easier...
Re: Remove or replace data source from Canvas app in new PowerApps Studio
I am getting this by Default. Don't have data option in ... menu
Re: Number of digits check
Hi @YoshikaSuzuki , What do your users use to enter numbers? A canvas app or a Model Driven app? Can you provide more details? What does ‘number of digits’ mean and why ca...
Re: If there is no data for the new month, add data from the last month
Hi @piotrgrendus87 , Please see below link to the workbook: Solution Regards KT
Re: Export Excel from a gallery
@gikido , Just use AddColumns for the rest, or better, do not restrict the columns in the Filter.
Re: New form submission - Duplicate error when it's not a duplicate
@Eveneggerud , Yes, equals will work if not case sensitive
Re: Prevent specific named attachment from being deleted.
Hi @DB300 , Put this on the OnRemoveFile of the attachment control If( CountRows( Filter( ThisItem.Attachments, DisplayName = "ManagerSignature.jpg" ) ...
Re: Export Excel from a gallery
@gikido , You can create a collection with the same filter as the gallery - this can export up to 2,000 records as per my previous post.
Re: Allow calculated field capability on primary field
This is essential given the requirement that the primary name column will be the only one displayed in lookup controls. Thus we need to make such a column meaningful. Your default tables (contact, ac...
Re: What JSON code would format my Created Sharepoint column in long date form?
Hi @mobilismexico , All you have to do, is change the Display Format from 'Friendly' to 'Standard'. You get there by clicking on the list settings and then clic...
Re: Default entry in form, dropdown,
Hi Zmansuri, It currently is a drop down box in a form. What I want to achieve is to have one of the options be displayed/chosen as a default so that if the client submits the fo...
