Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sudheerg
New Member

Create a user input form

Hello,

 

Can anybody assist me how to create a user input form in report. Once user fills the form and clicks submit it has to call API 1 which generates token and by using that token it has to authorize the 2nd API and send the data to the database.

 

Thanks,

Sudheer

1 ACCEPTED SOLUTION
v-sdhruv
Community Support
Community Support

Hi @sudheerg ,

You can use Power Apps-

Power BI + Power Apps Integration (Recommended for Microsoft Stack)

1.Create a Power Apps form:

Go to Power Apps and build a canvas app form with the fields you need.

On the submit button:

Call API 1 to generate the token.

Use that token to call API 2 with the user input.

Power Apps Logic (Pseudo-code):

1. Call API 1
Set(tokenResponse, PowerAutomateFlow.Run(inputFields...));
Set(token, tokenResponse.token);

 2. Call API 2 with token
Set(api2Response,
CustomConnector.CallAPIWithToken(token, inputData));

You might need to use Power Automate (Flow) to handle the API token generation and secure API logic.

Hope this helps!

View solution in original post

2 REPLIES 2
v-sdhruv
Community Support
Community Support

Hi @sudheerg ,

You can use Power Apps-

Power BI + Power Apps Integration (Recommended for Microsoft Stack)

1.Create a Power Apps form:

Go to Power Apps and build a canvas app form with the fields you need.

On the submit button:

Call API 1 to generate the token.

Use that token to call API 2 with the user input.

Power Apps Logic (Pseudo-code):

1. Call API 1
Set(tokenResponse, PowerAutomateFlow.Run(inputFields...));
Set(token, tokenResponse.token);

 2. Call API 2 with token
Set(api2Response,
CustomConnector.CallAPIWithToken(token, inputData));

You might need to use Power Automate (Flow) to handle the API token generation and secure API logic.

Hope this helps!

Thank you @v-sdhruv 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.