Hi,
We have the below scenario which is built using Power Apps and Power Automate flow.
1. A Power Apps form with multiple fields for business user to fill in.
2. The form contains 4 fields that are dropdowns. The value list for the dropdown comes from SAP ODATA connection that gets the values using the ODATA service at the time the form is loaded for the users to fill in.
3. The user fills the form, field by field, using the value list got above. Once the form is filled in the user submits the form and all the fields on form are stored on Sharepoint.
4. The submit button also triggers a power automate workflow for approval.
5. The approval workflow has an edit link to the form, using which the approve can edit the values in the form.
6. The user after editing the values in the form, can approve the form for posting into backend SAP system.
ISSUE faced:
1. The odata services work fine when we initially call the power apps form.
2. When the power apps form is opened through the edit link, the odata services get corrupted.
By corrupted what happens is -
The ODATA call consists of a Base URL (host, port and base class) and then an entity set (similar to a method) that points to the value list. In the power apps ODATA connector, we give the base URL separately and the entity set separately, as thats the way it has to be set up.
During the initial call of the form, the ODATA service call goes through correctly with correct combination of Base URL and the entity set.
But when we call the form through "Edit" Link during approval process, The base URL gets changed as below.
Initial PowerApps form ODATA Connection 1 : Base URL ODATA 1 + Entity Set ODATA 1
Initial PowerApps form ODATA Connection 2: Base URL ODATA 2 + Entity Set ODATA 2
Edit Link PowerApps form ODATA Connection 1: Base URL ODATA 1 + Entity Set ODATA 1
Edit Link PowerApps form ODATA Connection 2: Base URL ODATA 1 + Entity Set ODATA 2
This makes the ODATA call to fail.
Questions:
1. What makes the ODATA URL corrupted though the connection parameters are set, especially with the edit form link?
2. How to resolve this issue so that the ODATA service gets called correctly?
3. What settings should be done to ensure that the ODATA service does not get corrupted.
Looking forward for answers,
Thanks,
Rashmi.