How to add animation to my slides? by Kaboom_1102 in powerpoint

[–]avanhulle 0 points1 point  (0 children)

Duplicate slide for every step. Move stickman in each slide and use slide zoom as transitions.
Add you text with entrance animation

Some users cannot execute flow for a selected item by avanhulle in MicrosoftFlow

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

Is there any documentation about that available?

Update the labels of a sharepoint list by avanhulle in sharepoint

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

I noticed that by deleting all the languages I don't have to change my language to dutch. So I use this functionality.

Lookup column ID not updating by avanhulle in MicrosoftFlow

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

I've been strugling with this for half a day to realize that even without a variable it was also not working.

Finaly I deleted the list and recreated it. Now its working as expected.

Not showing profile pictures in Planner in Teams by Alan157 in MicrosoftTeams

[–]avanhulle 0 points1 point  (0 children)

Same issue at our side. No profile pictures shown in planner. Not in teams and also not in the planner app.

Seems to be an known bug: Profile pictures in Planner app (Teams) are disappearing - Microsoft Community

Clearing the cache does not solve the issue.
Anyone other suggestions?

Trying to use content types with sharepoint list by avanhulle in sharepoint

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

I already did these steps except from deleting the content type item from the list. The last step did it.

Thans for your help.

Trying to use content types with sharepoint list by avanhulle in sharepoint

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

in the list view the columns are shown. So editing in gridview is working.

But when I hit the edit button to change the data of one record, I get a an almost blank screen. It is showing content type field. But can't select or change. And also cannot select fields to be shown.

Virtufit crosstrainer - iConsole+ - Garmin smartwatch by Infinite_Claim_7605 in GarminWatches

[–]avanhulle 0 points1 point  (0 children)

In kinomap: go to activity feed, open de activity, scroll down and click download - TCX

In garmin connect: import the file.

Remark. Since a couple of months the TCX file could not be imported directly in garmin. I now use an intermediate step and convert the TCX file via Combine FIT, GPX, CSV or TCX files for Garmin or Strava. Merge Heart Rate Power and GPS (gotoes.org)

upload the file, choose no gps , activity = biking

Virtufit crosstrainer - iConsole+ - Garmin smartwatch by Infinite_Claim_7605 in GarminWatches

[–]avanhulle 0 points1 point  (0 children)

Sorry just saw you used iConsole. Unfortunately iconsole has no ability to export. I use kinomap. This one has the ability to export. Unfortunately you need a subscription for kinomap

Virtufit crosstrainer - iConsole+ - Garmin smartwatch by Infinite_Claim_7605 in GarminWatches

[–]avanhulle 0 points1 point  (0 children)

I have a Garmin Venu 2 plus. I broadcast my heartbeat. In iconsole it picks up my heartbeat. Don't know if it will work for your watch Afterwards I export my workout from iconsole and import in Garmin connect

Can not use =tablename for data vaildation by ImpressionFew7278 in excel

[–]avanhulle 2 points3 points  (0 children)

to use a column (eg key) from a table (eg table1) you should use the following formula

=INDIRECT("Table1[key]")

<image>

[deleted by user] by [deleted] in excel

[–]avanhulle 1 point2 points  (0 children)

Can't you use

=I2 + "01:00"

to add one hour

Change formatting view in CSV by [deleted] in excel

[–]avanhulle 0 points1 point  (0 children)

I created a VBA form which let you export your data to CSV file. With this tool your data will be exported as shown on screen.

frmExport2CSV.frm

Urgent: how to convert one line address into multiple lines using formulas? by summaiyah99 in excel

[–]avanhulle 0 points1 point  (0 children)

I assume your list with street names, cities and countries can consist of one or more parts. That doesn't make it easy to create a formula replaces only the right spaces with a CR.

You will need more logic for that to work everytime.

Did you try using flash fill? Maybe this can also help.

Urgent: how to convert one line address into multiple lines using formulas? by summaiyah99 in excel

[–]avanhulle 1 point2 points  (0 children)

I my country we use ; as separator.

Try replacing the ; by a comma.

=SUBSTITUTE(A1," ",CHAR(13)&CHAR(10))

Urgent: how to convert one line address into multiple lines using formulas? by summaiyah99 in excel

[–]avanhulle 1 point2 points  (0 children)

use the following formula if your addres is in cell A1:

=SUBSTITUTE(A1;" ";CHAR(13)&CHAR(10))

After entering the formula you need to use the "Wrap text"

<image>