Power Apps Search
Search
Re: Replace Text Box in Browse Gallery with a Dropdown
@RussellM Sorry, this is due to column Name. SortByColumns(Filter([@'Shelves(2)'], IsBlank(Dropdown1.Selected.Value) || IsEmpty(Dropdown1.Selected.Value) || 'POP Name'...
Split single cell data to multiple rows to respective columns in power automate(sharepoint as datasource)
Hello All, I created a gallery and saving the gallery data in sharepoint by concatenating multiple lines to single line with delimiter. in below image you can see how it is saved. I have to se...
Re: How to access an added table column
OptionSet
Patch function returns blank record on related table
Hi! I have a main table which is called requisition header. I also have related tables: Requisition Form, Requisition - Attachments I store the patch code of the 'Header' table inside a variab...
Re: Managed solution dataverse tables query
Thanks @Fubar silly me didn't even try that ! because everything I read previously seemed to point to the fact that I had to recreate everything in the new environment.. I did import the tables ...
Deep Link to Form from an email URL in Canvas App
Hi, I have a Data Table that is hooked up to an edit form. The data is being populated from a SharePoint List. Data source is called CUOTasks On the items of the data table I have: Set(_ItemSelec...
Re: Load multiple tables using query
Hi, @Daryl-Lynch-Bz Thanks for the Reply, Yes I want to Load tables Separately
Re: How can I adjust Hoosier's M query so that it retrieves my SharePoint list data?
I tried this and after publishing the report, the refresh failed with the error - This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the ...
Database Design
Hi all, I must have an efficient way to connect two records from a table. The table holds records of Laboratory tests wich have a start date and a duration in days. I got a request from my ...
Problems with initialized variables not being populated OnStart
Hi there, I am having a problem with my variables that I have defined in the OnStart property of the App: Suddenly, they are not populated/shown when I run the published app. While the first vari...
Re: Add Custom Column based on calculated date ranges from current date
@gton22 You can create a configuration table either in between the same query or a different query, paste this code in the advanced editor: let Source = Table.FromRows ( ...
Delagation Error with Dataverse Using Lookup
First image having label data formula Second is item in gallery to show data formula but its showing Delegation warning Please help @WarrenBelz @Kameshm05 @RezaDorrani&...
sorting dropdown alphabetically
Hello, How do I sort the dropdown items alphabetically ? I tried in so many way but nothing works .
Re: Problems with initialized variables not being populated OnStart
That sounds like a great advise! Thanks a lot @iAm_ManCat , will try that out.
Re: sorting dropdown alphabetically
I dont see any items if I put Ascending in items.
Re: sorting dropdown alphabetically
My bad, should be this: Sort(Choices([@FDW_Sportarten].SportartID),Ascending)
How to Relate this two Patch functions ?
Hello, I want to know how i can relate this to Patch functions ? Patch(Reservierungs;Defaults(Reservierungs); {StartDatum: StartDatum_DataCard2.Update; EndDatum: En...
Re: LookUp formula not working
Hi! So, first of all we should find a way to avoid nesting those lookups as they can cause excessive network traffic - can I assume that your Departments list is not a huge list? less than...
Re: Patch Deployment
@Innrg I have no idea what you are referring to.
Re: Patching Dataverse with a Collection - Invalid argument type (Table). Expecting a Record value instead
@Tolu_Victor I forgot to respond back here, but I was able to resolve my issue with the below updates. Below is the snippet for the loadButton to add changes to the collection before patching...
My App is not updating when a new item is added in SharePoint List
Hi All, I am having an issue with my app gallery. When I add a new item to the SharePoint List in SharePoint, the new item is not showing in my app gallery. I have tried simply refreshing th...
Re: Need help to find the right formula for a piechart and sharepoint list with column choice
My bad It should be ClearCollect We need it to refresh the collection each time
Re: Updateif and attachments
Resolved it after some more testing! Used Patch If( varEdit, Patch( 'Safety Information', varCurrentID, Section9.Updates .....
Re: SharePoint Edit form not publishing new layout
Hi @mjjones Can you check if the following is true? 1) The new form was published 2) The SharePoint list is using the new form &...
Re: For all patches only the first item in the gallery
I believe this occurs because you are patching Ratios AND looking up Ratios. A workaround is to first rename the column first. Shane Young explains it better than I could: https://yo...
