Answered

Getting data from an API

(0) Share

Report

Posted on by Muk_xo

Hello, I am trying to display (GET) staff information from an API I have added as a data source. I would like to filter this information by "email" and display the necessary staff data, either as a gallery or form, depending on which works best.

profile page

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!

All APIs are different. Most public APIs have documentation that will list out all the available options and provides examples of queries and responses. This is typically the best place to start.

Was this reply helpful? Yes No
Muk_xo 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, the API was created by my colleague, specifically for this purpose. I added it as a new connector via the dataverse. The data comes up in certain circumstances like when I use a drop down. However, I would like it to populate the whole form/gallery etc by filtering based on staff email.

Was this reply helpful? Yes No
Verified answer

Muk_xo 21 on at

Like
a
(1)

Report
Copy link

Link copied!

After attempts with my colleague we were able to arrive at the solution. Using the following in the formula bar:
First(Filter(StaffDB.Getstaffdata(), StartsWith(email, User().Email) )).idNo for the ID input box and .profession for the jobtitle input box...etc as seen in the pic above.

Was this reply helpful? Yes No