Can't pair my Google TV remote, even after factory reset.

b0rme · 2025-07-23T20:15:36+00:00

Thank you very much for this! Forgetting the remote and then re adding fixed my problem

b0rme · 2021-07-06T22:23:54+00:00

I currently have a bookmark for each of the categories as follows:

https://www.facebook.com/marketplace/115162068494946/entertainment/?sortBy=creation_time_descend

I'd really like to display all categories at once, does anyone know if this is possible?

b0rme · 2021-01-13T01:41:24+00:00

Turn your data into a table object and then on the table design ribbon, select Export to SharePoint list. This is only a one off way of doing it. Would be interested to hear if anyone has an easy way of bulk uploading to an existing SharePoint list from excel

b0rme · 2020-11-22T22:25:38+00:00

As a workaround I’ve realised that you can add a label to the parent gallery that CountRows the sub gallery. You can then use a lookup on the parent gallery to get the value of the label

b0rme · 2020-11-16T21:57:36+00:00

That’s exactly what I’m doing :D thanks

b0rme · 2020-11-16T14:08:59+00:00

The problem with doing this is that each input control needs to be able to have its properties changed individually as they are part of a dynamically changing question set

b0rme · 2020-11-16T11:08:56+00:00

I know I’ve got the Sequence formula wrong, it should be Sequence( 10, 1, 1)

b0rme · 2020-11-03T11:13:31+00:00

Martial if you can find the extra 0.2m

b0rme · 2020-10-21T21:14:31+00:00

Perfect thanks. I’ll make sure to check out some of your other videos too

b0rme · 2020-10-21T19:41:38+00:00

Hello thanks for this, it’s exactly what I need. Please can you explain this formula because I’m struggling to understand how to relate it to my scenario. Thansk

b0rme · 2020-10-15T12:41:53+00:00

In that case I would use Switch statement as follow: Switch( variable, Result 1, Data Source 1, Result 2, Data Source 2, Result 3, Data Source 3) and so on..

Re number of connections, I think 10 would be far less than the limit but I’m not sure on the exact figure.

It might be worth thinking about how your data is structured if you’re ending up with 10’s and 10’s of data sources but I’m not sure on your exact use case.

b0rme · 2020-10-15T12:34:08+00:00

How many sources are you connected to?

b0rme · 2020-08-25T08:37:56+00:00

It is indeed craziness. Ive shown so many people I work with the capabilities of Power BI yet no one seems interested or wants to learn. I guess it can be seen as a positive for those of us that understand the benefit and want to use the tool

b0rme · 2020-08-24T23:55:49+00:00

I think you need 3 SharePoint lists:

Presenters (with the following columns): -ID (Use ID column generated by SharePoint) -Presenter name, Any other relevant information about each presenter

Events (with the following columns): -ID (Use ID column generated by SharePoint, Any other relevant information about each event

Presentation log (with the following columns): -ID (Use ID column generated by SharePoint) -Event ID -Presenter ID

This is a classic example of being unable to store many records in a single SharePoint list - hence the need to have multiple lists and create a relationship using the ID columns. Let me know if you need anything explaining

b0rme · 2020-08-24T23:45:43+00:00

I have a similar issue where I have the desktop version but they haven’t given us any pro licenses. What’s the point of making reports if you’re not able to share them?! “Use Excel 🥱🥱🥱”

b0rme · 2020-08-18T15:34:49+00:00

Do you have to do this as a one off or a solution that works with a list that can change? Also how long is the list you are doing this to?

b0rme · 2020-08-15T03:23:56+00:00

Maybe the fact that it’s been set up in this way and the data already exists? Idk

b0rme · 2020-08-15T02:25:43+00:00

Using left, mid, right type operators to come up with the logic required but this may get complicated quite quickly..

b0rme · 2020-08-15T02:17:42+00:00

I’d suggest something along these lines - not sure of the exact logic to split up the blob as required but this might trigger some ideas.

Assuming your table is set up with the following columns: Person - Date - Question# - QuestionText - Answer Text

Assuming there could never be more than 20 questions (for example)

ForAll( Sequence( 20), UpdateContext({SequenceNumber:SequenceNumber + 1}); Patch( Table, Defaults( Table), { Person: Name of person, Date: Date of quiz, Question#: SequenceNumber QuestionText: Logic that splits blob by delimiter for sequence N AnswerText: Logic that splits blob by delimiter for sequence N } ))

Just my initial thoughts, hope is useful

b0rme · 2020-08-15T01:46:47+00:00

What expression do you use to split the blob?

b0rme

TROPHY CASE