Answered

Constituency data

Like (0) Share

Report

Posted on 30 Mar 2025 07:59:06 by CD-28031715-0

I am very new to Power Apps. I am trying to add a Custom Connector in my Contact table. I want to be able use a postcode that is entered to work out the constituency that that postcode is in and to auto-populate a Constituency field. I'm struggling to know what information I need to put on each of the pages from (3) Definitions onwards. The host page is theyworkforyou.com. If anyone can help me with the data I need to insert in each of the fields in the Custom Connector or suggestions for another host page, if that is better, is good too.

Categories:

Authentication

All responses (6)

Answers (1)

CD-28031715-0 80 on 04 Apr 2025 at 18:43:55

Like (0)

Report

Constituency data

@vipuljain03 I don't think you've seen my reply below, to be fair I didn't tag you... Are you able to help me please? I feel like I'm nearly there but just need that final bit of help...
CD-28031715-0 80 on 02 Apr 2025 at 13:30:53

Like (0)

Report

Constituency data

Your video is very useful Vipul, but I've got an error... I don't know what needs to go in the Output section. Also once I've got this sorted, I still don't quite understand how I instruct Power Apps to use the data in the Postcode column to populate the Constituency column in the same Table. Thanks so much for your help so far.
CD-28031715-0 80 on 02 Apr 2025 at 13:04:01

Like (0)

Report

Constituency data

Hi Vipul, thanks. I'll try to incorporate the custom connector in a model driven app, not canvas app. I'll try watching your video though and see if it enlightens me.
vipuljain03 464 on 31 Mar 2025 at 18:09:17

Like (1)

Report

Constituency data

Refer this video to get insights on Custom Connector and how you can use them in Canvas App - https://www.youtube.com/watch?v=A5rljz91zaM
CD-28031715-0 80 on 31 Mar 2025 at 17:43:57

Like (0)

Report

Constituency data

Thank you Vipul. I think I'm getting there... I followed your instructions and a Youtube video... I'm not sure that I've done everything quite right, but when I look at a list of current connections it says that it is Connected! I don't know how to incorporate it into my Model Driven App though... I will try and find a video to help, but if you see this reply and can point me in the right direction, I'd be very grateful. Thanks very much for your guidance so far!
Verified answer

vipuljain03 464 on 31 Mar 2025 at 07:11:26

Like (2)

Report
Constituency data

You are using TheyWorkForYou.com API.

The first and foremost step would be to get the API key. Maybe signup with TheyWorkForYou.com API and get the API key and save it.

1) Configure the General page in custom connector:

Scheme: HTTPS

Host: www.theyworkforyou.com

Base URL: /api/

2) Configure Authentication (API Key)

3) Definition

Create a new Action and name it GetConstituencyFromPostcode.

Fill in General Settings => Summary, Description and Operation ID (GetConstituency)

Setup the Request

Click "Import from sample"

Select GET method

Enter the URL (replace <YOUR_API_KEY> with {key})

https://www.theyworkforyou.com/api/getConstituency?postcode={postcode}&key={key}&output=json

Click Import

Define Parameters

postcode => Required, type: string

key => Required, type: string

Define the Response

Click "Add default response"

Click "Import from sample"

Enter a sample response

{
"name": "India"
}

4) Test your custom connector

--------------------------------------------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,

Vipul

Community site session details

Constituency data

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Constituency data

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates