Sharepoint ID extracted from filename in new column

[baneworth]

Hello Community,

I create entries for tool inspection with power apps loaded to a sharepoint list, this entries also include images.

Then i have a flow running which takes the images from the list and puts them into a sharepoint library (so i can link them with onedrive for easy access).

Now my company also wants powerbi analysis of this data  and link each entry with the image.

My issue now is, that in the image library i do not have the entry ID (available in the list) and therefore can not link this 2 tables.

But i do have the ID in the image name available as can be seen in below image -> red marked

Is there a way to create a new column in power query (or others) and extract this information?

- there are always 3 - and 1 -- before the ID, also the ID will stay at 4 characters for a very long time.

Thank you

Best regards

Matthias

[TomasAndersson · Accepted solution]

Hi!
You should be able to to a custom column using PowerQuery:

Text.Middle([Name], Text.PositionOf([Name],"--")+3, 4)

This finds the position of "--" and picks up the first four characters after "--",