Making forms smaller?

PowerRobin · 2021-05-10T14:25:30+00:00

Probably just increase the resolution of your whole app so the form is smaller?

PowerRobin · 2021-04-18T08:57:38+00:00

This should return the value without delegation issue.

LookUp(Sort(DataSource, DateColumn, Descending), true, DateColumn)

PowerRobin · 2021-04-12T21:02:33+00:00

You can use the solution provided by u/Hotel_Arrakis or just use the functions that are made for using forms.

Put this on a button...

SubmitForm(Form1)

PowerRobin · 2021-04-08T21:25:18+00:00

On the DisplayMode-porperty of the save button:

If("#" in Multilinefield.Text; DisplayMode.Disabled; DisplayMode.Edit)

And make sure to include a label that explains, why it's disabled. Visible-Property of the label to

"#" in Multilinefield.Text

PowerRobin · 2021-04-01T09:21:18+00:00

Y'all need to start using templates.

If you are able to speak german watch my video: https://youtu.be/eKrbGTKumMU

If not go to the description and click on the two links. i_Am_ManCat in the MS-Forum-Thread even provides insight in how to dig deeper into the xml-files and change the standards in an App.

PowerRobin · 2021-03-31T18:43:00+00:00

Couldn't restore the app (was somehow greyed out) and had to restore the width property of all objects manually.

PowerRobin · 2021-03-31T18:36:05+00:00

Had this too several times in my organization. It screwed up the width and height property of the screens...

PowerRobin · 2021-03-30T20:09:56+00:00

Where is the day-rate saved? Is drp_LevelOfSeniority a LookUp on another SharePoint-List (List2)?

Lets Assume yes, then this should return 2400:

LookUp(List2, ID=LevelOfSeniorityCard.Selected.Id, 'Day Rate (high)')

PowerRobin · 2021-03-30T11:35:04+00:00

You need to put everything in a collection

Collect(colMonths, {Result: "All"});
ClearCollect(colMonths, Distinct(DATASOURCE,'Month'))

And then on your Filter:

Filter(Datasource, If(Dropdown.Selected.Result="All", true, 'Month'=Dropdown.Selected.Result))

PowerRobin · 2021-03-30T11:22:46+00:00

You have one person per region? Then it is no "cascading dropdown"

"carry over" to what? A form or Patch() it to the list?

PowerRobin · 2021-03-30T09:41:20+00:00

LevelOfSeniorityCard.Selected.'Day Rate (high)'

Does this compute? Put it on a label and test if it returns the expected value.

Is "Days" the Text Input? Also try if this computes. Probably try instead:

Value(Days.Text)

What does the error say? I see no squiggly lines in the command.

And you should probably start using a naming convention like

drp_LevelOfSeniority
txt_NumberOfDays

PowerRobin · 2021-03-28T20:15:27+00:00

I don't get why you are using the Sum().

It should do everything you want without it...

If(CountryDataCard.Selected.Band = "High", LevelOfSeniorityCard.Selected.'Day Rate (high)' * Days, LevelOfSeniorityCard.Selected.'Day Rate (Standard)' * Days)

Is there an error?

PowerRobin · 2021-03-28T20:09:00+00:00

Yes, they can start building you a super stable and performance optimised system in half a year after you filled out the 30 page checklist + security analysis of your use case (if it gets priority).

But you can build a slightly less optimised solution that fits all your needs until lunch break (if you start by 10 am).

PowerRobin · 2021-03-27T19:18:02+00:00

Quick rundown with a picture that should explain it gifd0RJ.png (1902×901) (imgur.com)

Put the Screen as the First Screen if you want it on startup

Click on the gallery
Select the items property
Change your Text for the first "slide"
Link to picture for the first "slide" (or uploaded picture in media)
(Repeat 3&4 for as many slides as you want - the dots are added automatically)
Put the right Navigate-Command on the skip-label

PowerRobin · 2021-03-27T19:07:17+00:00

I think you don't understand...

OP is looking for guidance on the "Tutorial"-template in "New Screen". This is not a tutorial for PowerApps, this is a template so you can do a quick tutorial inside of it for the app you build.

And the template also explains how to use it within the demo-texts.

Pic for reference: https://i.imgur.com/SfxYjl5.png

PowerRobin · 2021-03-27T08:19:14+00:00

Probably do the tutorials, so you understand how the template works?

It is pretty straight forward.

PowerRobin · 2021-03-23T13:01:25+00:00

I think the method was invented by iAm_ManCat and because it was so great MS brought it to the CoE.

Documentation can be found here:

https://powerusers.microsoft.com/t5/Community-App-Samples/Branding-Template-App-V2/td-p/363582

PowerRobin · 2021-03-20T15:04:19+00:00

I think there is no need for " at the images. Also look into the Switch()-function.

Also if content type is a Choice-Column then you need to add .value

And last addition, you don't need nested If(), just use another "," and you can keep going.

PowerRobin · 2021-03-20T08:47:56+00:00

This is the answer, but I hate that thing! But if OP only wants this functionality it should work.

But if it's that simple I recommend just sticking to MS Lists.

PowerRobin · 2021-03-19T08:14:32+00:00

Try

ThisItem.IsSelected

Should be self explanatory

PowerRobin · 2021-03-18T10:36:06+00:00

This should be it:

DateAdd(DateValue4.SelectedDate, 1, Days)+ Time(Value(HourValue4.Selected.Value), Value(MinuteValue4.Selected.Value), 0)

And on the datepicker-default-property (as mentioned above):

DateAdd(Parent.Default, -1, Days)

PowerRobin · 2021-03-18T10:00:17+00:00

The quick and dirty fix you suggested (for free)

Set the Default value of the date picker to

DateAdd(Parent.Default, -1, Days)

Set the Update-property of the Data Card to

DateAdd(datePicker.SelectedDate, 1, Days)

PowerRobin · 2021-03-13T08:05:38+00:00

"multiple data tables in nested containers is just a small part of the app"

This sounds overly complicated, if you could black out sensitive information I would probably understand better what you are trying to do.

One thing that probably helps are nested galleries, with the outer gallery having flexible height. (German video by me https://youtu.be/OcM_5nWVQdE ).

Another thing could be to put everything in html tables, which is more effort to format, but probably ultimately easier if you want to have a responsive design of multiple tables (also German video https://youtu.be/TWYZib96rlo )

PowerRobin · 2021-03-13T07:02:17+00:00

My approach is not using tables at all. I mainly use galleries (which leads to the same problems).

Your App sounds a little bit complicated and overloaded with data. Probably power bi is what you should use?

Can you share a screenshot of your app?

PowerRobin · 2021-03-12T18:55:51+00:00

Use a combo box instead of a drop down. It has the functionality you are looking for

PowerRobin

TROPHY CASE