Hi @Beatrix1
you can set your excel column to date format. EX: "d/m/yyyy" only date. Once done you need to drop the connection and reconnect again in powerapps. Now you can see the updated column data type.
Step 1: Add the relevant column name in the gallery. Ex: Date column
Step 2: Select the field and in the formula bar and add the following formula:
Text(ThisItem.Date, "[$-en-US]dd/mm/yyyy")
2) For loading hyperlink as the picture. All you need to do is once you connected your data source. Then select the picture property and in the formula bar type "ThisItem.'Picture URL'' . The screenshot below for reference
Note: you need to make sure your image URL is public
Hope it helps.
------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
