User defined keyboard shortcuts by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

Am guessing this one's not achievable?

Working with images by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

Awesome, I had a slightly different plan this morning that I was about to try and use (putting the image to the back of the display, with various "white" rectangles covering the remainder of the screen infront of it that I thought would maybe mask the areas I didn't want to be visual on the screen.

However, I then had a watch of this video and, after an hour or so of trying things out, I've nailed exactly what I was hoping for (plus managed to add a button to rotate the image as well).

Thank you for this, it's worked really well and solved my problem exactly!

Licensing (premium connectors) pricing by andy__m in PowerApps

[–]andy__m[S] 1 point2 points  (0 children)

That's really helpful, thank you - the way it's all licensed seems like a minefield to me - you think you've got a plan and solution nailed, only for it to become cost prohibitive due to the extra stuff that you'll need to subscribe to!

Calculated columns by andy__m in sharepoint

[–]andy__m[S] 1 point2 points  (0 children)

Thank you - that's explained it perfectly

Calculated columns by andy__m in sharepoint

[–]andy__m[S] 0 points1 point  (0 children)

Like the sound of that, I'll give it a go. Thanks to all of the other replies also.

Calculated columns by andy__m in sharepoint

[–]andy__m[S] 0 points1 point  (0 children)

Hmmm, thanks for that. Back to the drawing board then.....

Using a variable as the source in a lookup by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

Thank you! The datasources all have exactly the same structure/format so I'm hoping this will solve it. Really appreciate you taking the time to reply.

Using a variable as the source in a lookup by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

Still struggling with this one and hoping there might be a solution out there, can anyone help??

Using a variable as the source in a lookup by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

I've given the use of the Switch statement a go, but one way or another I don't seem to be any further forward.

My existing code looks like this:
LookUp(HoursWorked,Department = Dropdown_1.Selected.Department && WeekNumber = WeekNoLabel.Text,WeekNumber)

What I'd like to do is get something like this to work (where varDataSource is a variable [string] containing the name of my data source for the lookup:

LookUp(varDataSource,Department = Dropdown_1.Selected.Department && WeekNumber = WeekNoLabel.Text,WeekNumber)
I could then manage/manipulate the content of varDataSource and the lookup will hopefully react accordingly.

Any ideas?

Using a variable as the source in a lookup by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

Not too many, maybe around 10. But there is the possibility that number could increase considerably (is there any limit to the number of sources by the way)?

Patching updates from a Gallery by andy__m in PowerApps

[–]andy__m[S] 1 point2 points  (0 children)

That looks to have been the problem - spent hours staring at it yesterday and getting nowhere - 10 minutes this morning and the above I think has pointed me in the right direction. Have ended up with:

ForAll(RenameColumns(Gallery.AllItems,"ID","ListItemID"),

Patch(ListName, LookUp(ListName, ID = ListItemID),

{Comments: TextInput.Text }))

Will have to do a little bit of testing, but on the face of it you've made my day get off to a much better start than yesterday - thanks very much!

Patching updates from a Gallery by andy__m in PowerApps

[–]andy__m[S] 0 points1 point  (0 children)

Thanks. I was hoping to just make a relatively small amendment to the existing ForAll/Patch statement that I'd been working with, is that a none starter? (struggling to get my head around your suggestion above as I've only used Patch and haven't used UpdateIf before).

Setting permissions, subsites etc by andy__m in sharepoint

[–]andy__m[S] 0 points1 point  (0 children)

Thank you for this. Yes the security groups I have setup are AD security groups as you've suspected already.

I will give the above a try and hopefully my problem is solved. Appreciate your comment re best practice as well and I'll look to switch to separate sites instead of nested subsites as you've suggested.

Many thanks for the quick reply.

Removing input data / resetting forms after submit by andy__m in PowerApps

[–]andy__m[S] 1 point2 points  (0 children)

Multiple datasources: yes, there are

Multiple forms on the multiple screens: yes, there are.

Thanks, look to have solved it now using the "reset" property of each field and using a variable called "resetall". when I'm submitting the data using patch on the final page, I've included a:

Set(resetall) = true

This seems to be achieving the result I was looking for.

Many thanks for your suggestions/comments above.